May 19th in Formulas by .

Upper to Lower Case Function “=PROPER()”

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

Owner and site operator for Excelbuddy.com

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

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

8 Comments

Leave a Reply

Excelbuddy.com Get your excel questions answered in our forum!