You can use a formula and a help column

=UPPER(A1)

or for multiple changes use VBA

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


scroll down halfway until you see the UPPER macro

Regards,

Peo Sjoblom

"formhelp" wrote:

In Word I know that we can change the font of an entire document from
lowercase to uppercase without having to re-type the document...is that
possible in Excel?