CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING

M

MAXXMAS

I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS
 
J

Jacob Skaria

In anotehr column apply the below formula and copy down as reuauired. Once
done copy>PasteSpecial>Values to convert formulas to values...

=LOWER(A1)
 
P

Paul C

Use the formula LOWER(A1) in an empty column and copy down.

Then copy and paste special as values over your original data. You can then
delete the formulas.
 
B

Bill Sharpe

MAXXMAS said:
I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS

and in the future, toggle your caps lock key off...

Bill
 

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

Top