Excel - Capital letters to small letters and vice versa


This query is : Resolved 

(Querist)
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?

alok (Expert)
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

Anil (Querist)
13 March 2008 Thank you very much Alokji.

laxman (Expert)
20 March 2008 only function is there to change.
For UPPER case- =UPPER(ragne)
for lower case- =Lower(range)

laxman (Expert)
20 March 2008 only function is there to change.
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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details