M MAXXMAS Dec 11, 2009 #1 I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT HAVING TO TYPE IT OVER AGAIN. TKS
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 Dec 11, 2009 #2 In anotehr column apply the below formula and copy down as reuauired. Once done copy>PasteSpecial>Values to convert formulas to values... =LOWER(A1)
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 Dec 11, 2009 #3 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.
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 Dec 13, 2009 #4 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
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
