G Guest Feb 9, 2005 #1 I want ot change a Excel speadsheet from a combination of upper and lower case to all uppercase ie all 'Capitols'. Thanks
I want ot change a Excel speadsheet from a combination of upper and lower case to all uppercase ie all 'Capitols'. Thanks
F Fred Smith Feb 10, 2005 #2 Try the UPPER function. If you want to do it programmatically, you will need a macro.
J JE McGimpsey Feb 10, 2005 #3 Take a look here: http://www.mvps.org/dmcritchie/excel/proper.htm#upper