MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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