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.
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!
June 8, 2009
Nice explanation. This will be handy in my daily job.
July 29, 2009
Thank you for sharing this!
August 13, 2009
brother wonderful explanation
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
August 18, 2009
good detail tutorial
August 18, 2009
Thank you for the positive feedback!