How do I change a column in Excel from upper case to lower case?
How do I change a column in Excel from upper case to lower case?
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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Debbie Kennedy" <Debbie [email protected]> wrote in message
news:[email protected]...
> How do I change a column in Excel from upper case to lower case?
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 [email protected]> wrote in message
news:[email protected]...
> How do I change a column in Excel from upper case to lower case?
Try David McRitchie's "Lower_Case" macro:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower
In article <[email protected]>,
"Debbie Kennedy" <Debbie [email protected]> wrote:
> How do I change a column in Excel from upper case to lower case?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks