Is there a way to take text that is all caps and change it to all lower case? Thanks Chris
G Guest Jan 5, 2005 #1 Is there a way to take text that is all caps and change it to all lower case? Thanks Chris
J JE McGimpsey Jan 5, 2005 #2 WIth formulae, using a helper column: =LOWER(A1) or via macro, in-place: http://www.mvps.org/dmcritchie/excel/proper.htm#lower
WIth formulae, using a helper column: =LOWER(A1) or via macro, in-place: http://www.mvps.org/dmcritchie/excel/proper.htm#lower