How to capitalize the letters

Nidhi Jain (CS ) (987 Points)

21 June 2011

Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????

Reply
Follow
Share

3 Replies

* Krishna * (CA Student) (6149 Points)
Replied 21 June 2011

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.

1 Like

Nidhi Jain (CS ) (987 Points)
Replied 21 June 2011

Thanx Krishna

Priyanka (Assistant Company Secretary) (905 Points)
Replied 22 June 2011

Thanks even i was looking for the way:)

Start a New Discussion