Can any one tell me if something written in small letters in excel than how to convert it in Capital letters and vice versa????????
Menu
How to capitalize the letters
Replies (3)
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
Thanks even i was looking for the way:)
Recent Topics :
- Gift of unlisted shares to friend upon marriage
- Utilising Section 54(F) for capital gains reinvest
- GST ewaybill closure and Bill to ship to GST numbe
- TDS ON PARNTER INTEREST
- Share important chapters of ca inter costing
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
Related Topics :
CAclubindia
