CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
 

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

CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
 

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

=LOWER(A1)
--
Jacob


"MAXXMAS" wrote:

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

CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
 

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.
--
If this helps, please remember to click yes.


"MAXXMAS" wrote:

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

CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
 

MAXXMAS wrote:
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