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

I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'.

Thanks

Try the UPPER function.

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

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"AllenH" wrote in message
...
I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'.

Thanks

Take a look he

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

In article ,
AllenH wrote:

I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'.