banner_ad

Excel - Capital letters to small letters and vice versa

This query is : Resolved 
Profile Image

Profile Image

(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?
Profile Image

alok

Profile Image

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
Profile Image

Anil

Profile Image

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

laxman

Profile Image

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

laxman

Profile Image

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


CCI Pro
Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
ARTICLESHIP 30 April 2026
Article Assistant

J SINGH & ASSOCIATES

Ahmedabad

CA Inter

View Details
Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
26 April 2026
Chartered Accountant

Source HR

Mumbai

CA

View Details
Company
12 May 2026
Accounts Executive

Nafa Group

Mumbai

B.Com

View Details
Company
11 May 2026
CA Dropout

Patron Accounting LLP

Pune

CA Inter

View Details
Company
02 May 2026
Experience Audit Manager

AGGARWAL SAMIR & CO

New Delhi

CA Inter

View Details