Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????
Nidhi Jain (CS ) (987 Points)
21 June 2011Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????
* 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.
Priyanka
(Assistant Company Secretary)
(905 Points)
Replied 22 June 2011
"Live class on Python for Financial Analysis: Unlocking Efficiency in Accounting and Finance"
GST Live Certification Course (39th Batch) - April 2024 (Weekend Batch) (With Certificate)