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