Tuesday, September 15, 2009

PROPER Function

The following formula easily tranforms 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
Posted by at

1 comment:

  1. UnknownSeptember 21, 2009 at 7:11 PM

    This content is stolen from Excelbuddy.com If this is not removed immediately, charges will be pressed. A complaint is being filed and Google has been contacted.

    ReplyDelete

Subscribe to: Post Comments (Atom)