Hi
This is one of many useful functions which are included in ASAP Utilites'
add-in. For more information, go to:
www.asap-utilities.com
Another way is to use the UPPER() function. You'll have to use helper cells
to store the uppercase results.

--
Andy.


"Vicki M" <Vicki wrote in message
...
How do I change all of the font on my worksheet to caps.
I pull my information from a database where the names are in both upper
and
lower case and would like to have everything uniform.
I know in Word it can be done, but do not know how to do it in Excel.
Thanks for any help.