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,
"Debbie Kennedy" <Debbie wrote in message
...
How do I change a column in Excel from upper case to lower case?