How to capitalize the letters

In Excel, First go to next cell where you want the CAPITAL LETTERS.

Then, Use the Formula =UPPER(select the concerned cell where it has small letters)

Then all the letters will be converted into CAPITAL LETTERS.

But, if you want only Initial letter only should be converted into Capital letters, then use the formula =PROPER(select the concerned cell)

Hope this helps. Post it again if you find difficulty.

Thanx Krishna