You can't change to all caps with a formula, you can use a help column where
you put the formula, assume that A1:A200 are the values you want to have in
caps, if B1 is not empty select B and insert a new column, then in B1 put

=UPPER(A1), copy down 200 rows, select and copy then paste special as
values, finally delete column A and the help column will be A

Otherwise you have to use a macro

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

scroll down until you see Uppercase





Regards,

Peo Sjoblom

"modify email template" wrote:

I need to enter a formula so a specific column on my spreadsheet will haave
all CAPS. I need step-by-step to enter this formula. Can anyone help?