Excel - Capital letters to small letters and vice versa
This query is : Resolved
12 March 2008
Is there any command in MS Excel to convert capital letters to small letters and vice versa that are there in a sentence?
Is there any command in MS Excel to convert capital letters to small letters and vice versa that are there in a sentence?
12 March 2008
No anil ji there r no command in ms excel to conver capital letter to small letter or vice versa. but u can use the following formula for this:
to change text in UPPER case- =UPPER(ragne)
To change in lower case- =Lower(range)
to change in title case- =Proper(range)
may be ur prob will be solved
to change text in UPPER case- =UPPER(ragne)
To change in lower case- =Lower(range)
to change in title case- =Proper(range)
may be ur prob will be solved
20 March 2008
only function is there to change.
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)
20 March 2008
only function is there to change.
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Supply through E-commerce Operators
- STCG....................................................
- AMOUNT RECEIVED UNDER COMPULOSRY ACQUISITION OF AGRICULTURAL LAND
- TAN for Partnership
- Sales return eway bill
- Relief u/s Section 89
- REGARDING GST LIABILITY/....
- Specified Profession
- Is E Way Bill Valid If Transport ID Not Mentioned in PART A But Vehicle details mentioned in PART B
- STCG FOR GOLD ETFs
- Section 54F - Exemption on LTCG in 2026 for HP purchased in 2023
- Sales amount in Gstr1
- CG after sale of flat
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
