Your suggestion will work but will require two cells one for the OP to enter
the information and another to change it to caps - as I'm sure you are well
aware of.

"Sasikiran" wrote:

Dear Prashant,

Use =UPPER() formula

A1 prasanth B1 =UPPER(A1)


"Prashant" wrote:

Hi All,

Need your help!!!

I need a setting/formula/Coding in such a way that whatever text I type in
sheet 1 it should automatically to be returned in Upper Case i.e. in CAPS.

I checked settings but did not find anything helpful.

Thanks in advance for your assistance!!!

Prashant.