Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?
|
#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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Debbie Kennedy" <Debbie wrote in message ... How do I change a column in Excel from upper case to lower case? |
#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, "Debbie Kennedy" <Debbie wrote in message ... How do I change a column in Excel from upper case to lower case? |
#4
|
|||
|
|||
Try David McRitchie's "Lower_Case" macro:
http://www.mvps.org/dmcritchie/excel/proper.htm#lower In article , "Debbie Kennedy" <Debbie wrote: How do I change a column in Excel from upper case to lower case? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel case changes on a column of first names | Excel Discussion (Misc queries) | |||
TURN LOWER CASE TO UPPER CASE IN EXCEL? | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) | |||
Spellnumber | Excel Worksheet Functions |