Thanks paul.. As i too didn't get any idea than which you have specified
belwow, i too used the macro function to check.
Anyways thanks once again paul:)
Regards,
Ram.
On Mon, Apr 13, 2009 at 6:36 AM, Paul Schreiner wrote:
> Well... to answer your EXACT question,
> there isn't a simple function to do that. (that I know of!)
> However:
> If you're wanting a FORMULA, then you can use:
>
> =IF(EXACT(A1,UPPER(A1)),"Upper",IF(EXACT(A1,LOWER(A1)),"Lower","Mixed"))
>
> If you're wanting a function:
> I inserted this function into a Module:
>
> Public Function Check_Case(Str As String)
> If (Str = UCase(Str)) Then
> Check_Case = "Upper"
> ElseIf (Str = LCase(Str)) Then
> Check_Case = "Lower"
> Else
> Check_Case = "Mixed"
> End If
> End Function
>
> hope this helps...
>
> Paul
>
> --
> *From:* ram kumar.m
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, April 13, 2009 6:12:03 AM
> *Subject:* $$Excel-Macros$$ Function to Find the word is in Upper case or
> lower case or mixed
>
> Hi,
>
> Is there any function to find whether the word entered in a cell is fully
> in upper case or lower case or in mixed case?
>
> Can any one please help me as soon as possible...
>
> --
> Thanks and Regard
> ramkumar.m
> HAVE A NICE DAY FRNDS:)
>
>
>
>
> >
>
--
Thanks and Regard
ramkumar.m
HAVE A NICE DAY FRNDS:)
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---