Caps to lower case

[Guest]

Is there a way to take text that is all caps and change it to all lower case?

Thanks

Chris

 

[JE McGimpsey]

WIth formulae, using a helper column:

=LOWER(A1)

or via macro, in-place:

http://www.mvps.org/dmcritchie/excel/proper.htm#lower

 

[Paulw2k]

=LOWER(A1), where the uppercase text is in A1.