Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????
Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????
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
CAclubindia
