M Max May 2, 2005 #2 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
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 May 2, 2005 #3 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,
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,
J JE McGimpsey May 2, 2005 #4 Try David McRitchie's "Lower_Case" macro: http://www.mvps.org/dmcritchie/excel/proper.htm#lower
