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
Click to expand...

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

Bill
 
Top