excell
Posted by Jeana on September 21, 2001 8:49 AM
how do i change all my capital letters in excell to lower case (without retyping them?)
Posted by Tom Urtis on September 21, 2001 8:59 AM
Try the LOWER function in a formula.
Assuming you mean capital letters in text, such as with names or proper nouns, let's say your data is in column A starting in row 2. In B2, enter:
=IF(A2="","",LOWER(A2))
and copy down as needed.
Afterwards, you might optionally want to highlight the new range in column B, select Edit > Copy, then select Edit > Paste special > Values.
Tom Urtis
