How do I change a column in Excel from upper case to lower case?

M

Max

Assume data in col A, A1 down
Put in B1: =LOWER(A1)
Copy down

Copy col B, then overwrite col A with a paste special > values
Delete col B
 
A

Alan

If your upper case data were in A1 to A whatever, in B1
=LOWER(A1)
drag B1 down as necessary to the end of your range in coulumn A
see also
=UPPER(A1) and
=PROPER(A1)
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lower-Case Characters 2
Upper case to Lower case 5
upper case letters 4
filtering to separate upper & lower case 5
Change lower case to upper case 6
Upper Case vs. Lower Case Add-Ins 5
Upper case to Lower case 7
In Excel, changing a range of cells to all caps. 2

Top