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
- REGARDING GST ON COMMERICIAL PROPERTY
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- ITC temporary reversal and reclaim
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- TDS U/S. 194NF
- Applicable TDS rate for sale of property in Nov 2024
- PAYMENT NOT SEND IN 180 DAYS
- MIS MATCH OF INVOICE NUMBER
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
CAclubindia
