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
- Reopen of assessment proceeding
- TDS on Consultancy- Non DTAA
- Depreciation of fixed assets- coop housing society in mumbai
- EXPORT BILL UNDER LUT FREIGHT CHARGE INCLUED IN INVOICE IT LIABLE TO TAX
- Gift Received from nonblood relative
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Rental income gst and it purpose
- Experts need help
- Management System (IMS)
- Reprocessing of rectification order AY 2025-26
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
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
