R Robin Jan 22, 2004 #1 I have a worksheet that is done in all caps. Is there a way to convert the worksheet to natural caps?
I have a worksheet that is done in all caps. Is there a way to convert the worksheet to natural caps?
G Gord Dibben Jan 22, 2004 #2 Robin If by "natural" you mean "Proper" as "This Is Proper Caps" you can use David McRitchie's PROPER Macro. http://www.mvps.org/dmcritchie/excel/proper.htm Gord Dibben Excel MVP
Robin If by "natural" you mean "Proper" as "This Is Proper Caps" you can use David McRitchie's PROPER Macro. http://www.mvps.org/dmcritchie/excel/proper.htm Gord Dibben Excel MVP