Dear Gaurav ,
thanks a lot !!!!!!

Shekhar

"Gaurav" wrote:

If your text is in A1. In B1, type, =UPPER(A1) then copypaste
specialvalues.


"shekhar" wrote in message
...
i want to know that if in excel sheet we type in small letter and we want
to
make that all in capital letter how to do that

regards,
shekhar