Hi Tom

Assuming that your data start in cell A2, try using this formula and copy as
far down as your data is :
=UPPER(A2)
Does this do what you want?
--
HTH

Appreciate that you click the Yes button below if this posting is helpful

cheers, francis
"Tommy" wrote in message
...
I need to have any text entered into a cell automatically changed to all
captials.
Is that possible? If so can someone please send the steps.

Thank you
--
Tom
/