The following formula easily tranforms 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!
discuss this topic to 