Excel - Capital letters to small letters and vice versa

This query is : Resolved

Anil (Querist)
Follow

12 March 2008
Is there any command in MS Excel to convert capital letters to small letters and vice versa that are there in a sentence?

alok

alok (Expert)
Follow

12 March 2008 No anil ji there r no command in ms excel to conver capital letter to small letter or vice versa. but u can use the following formula for this:
to change text in UPPER case- =UPPER(ragne)
To change in lower case- =Lower(range)
to change in title case- =Proper(range)
may be ur prob will be solved

Anil

Anil (Querist)
Follow

13 March 2008 Thank you very much Alokji.

Upgrade to CAclubindia Pro. Subscribe Now!

laxman

laxman (Expert)
Follow

20 March 2008 only function is there to change.
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)

laxman

laxman (Expert)
Follow

20 March 2008 only function is there to change.
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)