How can you change an Excel spreadsheet from a combination od Upp.

A

AllenH

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

Try the UPPER function.

If you want to do it programmatically, you will need a macro.
 
Top