Upper Case to Lower Case

[Jody]

Hi,

I have 20 columns X 4000 rows of labels that are
completely capitalized and I would like to convert
everything to lower case. The nature of the data is
different column to column.

MS-Word handles this nicely, however I can find a similar
command to do this efficiently in Excel.

Any suggestions?

Cheers,
Jody

 

[boy]

try =lower(a1)

where a1 is the cell where you have the all caps text

 

[Jody]

thank you. this will come in handy for doing individual
columns!

Cheers,
jody