Change case in excel
This query is : Resolved
17 August 2011
Dear Experts,
I request for a small information and that is as belwo:
In Excel how to change a letter from capital letter to small in a particular cell or some cells.
Thanks and regards,
rd
I request for a small information and that is as belwo:
In Excel how to change a letter from capital letter to small in a particular cell or some cells.
Thanks and regards,
rd
17 August 2011
EG. in case you have to shorten content of date in column C row 6 use formula in the next column =LOWER(C6)
In case you have to proper content of date in column C row 6 use formula in the next column =proper(C6)
In case you have to proper content of date in column C row 6 use formula in the next column =proper(C6)
17 August 2011
Dear Mr. Aditya,
Thanking you very much for your answer. But I am not getting it properly.
Just think in column C and Row 6 I have typed small letter. Now I need to change in same cell(col 6 & row 6) from small to capital.
Kindly guide me.
Thanks and regards,
R.D
Thanking you very much for your answer. But I am not getting it properly.
Just think in column C and Row 6 I have typed small letter. Now I need to change in same cell(col 6 & row 6) from small to capital.
Kindly guide me.
Thanks and regards,
R.D
17 August 2011
small to capital - =upper(c6)
10 October 2011
First apply the formula in a different cell. Then copy and paste special, as Values.
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
- Taxable or Tax exempt
- CAPITAL GAIN BASE ON NOTIFICATION
- TDS Deducted AY-2013-14 Not Reflected in 26as
- Demand Outstanding AY 2013-14 TDS Deducted not shown in 26as
- ADVANCE PAYMENT OF ADVOCATE
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Query – TDS on purchase of land from NRI under Income-tax Act, 2025
- Condonation . E-Verification of last year return .
- CREDIT NOTES WITHOUT GST
- Eway bill generation from place other than registeted
- 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
- LLP audit under companies act
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
