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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Should I report my US salary for January, February, March in Schedule FA?
- GST ON EXPORT COMMISSION
- Sale of property furniture sale
- BUYING PROPERTY COULD NOT FILE 26QB
- Gst input for FY 23-24
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
