May 19th in Formulas by Excelbud .

Upper to Lower Case Function “=PROPER()”

The following formula easily tranforms a list of data from Upper to Lower case.

Excelbud

Owner and site operator for Excelbuddy.com

The following formula easily transforms a list of data from Upper to Lower case.

Start with a list of data.
Next, place your curser in Cell C1 and enter the following functions as shown. =PROPER()
Enter the cell A1 between the parenthesis. =PROPER(A1)
Now drag the formula down to convert the remaining names to lower case. Simple huh!

Dave . June 8, 2009 .

Nice explanation. This will be handy in my daily job.
andy . July 29, 2009 .

Thank you for sharing this!
YOUNUS . August 13, 2009 .

brother wonderful explanation
Ramanathan . August 18, 2009 .

Nice tips :

I am searching for this for a long time. as in word how to convert to smaller case in xcel.

thanks a lot
Ramanathan . August 18, 2009 .

good detail tutorial
Excelbud . August 18, 2009 .

Thank you for the positive feedback!
Pambaa » Blog Archive » Upper to lower case function . November 29, 2009 .

[...] VIEW TUTORIAL AKPC_IDS += "180,";Popularity: unranked Share and Enjoy: [...]
Zaigham . January 9, 2011 .

Use “=LOWER()” and “=UPPER()” in same way to get the sentence all in lower or upper.