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
- About TDS & Income Tax
- PPF interest-As Exempt Income disclosure
- Section 194JA & JB Income which ITR Form to use
- Pass word to open justification report for Q1 for FY 2026-27
- Under construction property in ITR
- Scrutiny and reopening of past returns
- Booth for sales promotion
- Building tax payment deduction in rental Income
- Upload Level ValidationITR3Category of Defect B/D
- Foreign inward in ITR
- TAX AUDIT QUESTION
- VALUATION OF PRIVATE LIMITED COMPANY SHARES
- LIABILITY ADJUSTMENT
- Capital Gains on sale of residential flat
- Accounting with Claude
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
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
