Hi Tom

you should enter the formula in B2 and copy down.

--
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
/