Your function is: UPPER
You may use it in an adjacent sheet to achieve what you want OR to run a
macro on all the used-cells in your sheen to change the appropriate letters.
Micky


"Santhosh" wrote:

How to change all the small letters in a work sheet to caps letters