CAPITAL TO SMALL CASE

FRENZ,

 

IN EXCEL IF YOU WANT TO CHANGE THE CASE OF A SINGLE CELL OR MULITIPLE CELL, SAY FROM CAPS TO SMALL

THEN GO TO AN EMPTY CELL AND TYPE THE FORMULA =LOWER(A3), IF THE ORIGINAL TEXT LIES IN 3RD ROW AND "A"TH COLUMN.

THEN YOU COPY THE NEW TEXT, AND USING VALUE OPTION ON PASTE SPECIAL, AND YOU CAN PASTE IT WHEREVER YOU WANT. EVEN IN THE ORIGINAL TEXT PLACE.

IF YOU WANT TO CONVERT INTO CAPS

USE

=UPPER

AND

IF YOU WNT TO DO IN TITLE CASE

USE

=PROPER              FUNCTIONS.

Replies (9)

You can also copy paste from word to change case in excel. To do frequently, use specific addins written for that. I am attaching Letter case addins (by Shailesh) to change case in excel. Unzip and Save the addins to your document & open from it. You can see one popup toolbar will appear. Click on the button from this toolbar to see the option for changing the text case (i.e. ALL CAPITAL, small case, Sentence case, Proper Case). This is the fastest way to change case in excel as there is yet no inbuilt functionality given in excel-2010 also.

you can also download it from below site.

https://shahshaileshs.web.officelive.com/Addins.aspx

here is the attachment

Another addon to work on larger data size for changing case with fastest way in excel.

Unzip attached file, run setup to install this comaddins. To uninstall you can do it from Add/Remove Programms from  Control menu.

Another addon to work on larger data size for changing case with fastest way in excel.

Unzip attached file, run setup to install this comaddins. To uninstall you can do it from Add/Remove Programms from  Control menu.

Thanx a lot for the info

how to use provide syntax please.

See attached sample for formulat to use.

If you have a sentence in cell C2  and you want to make only the first word capitals do this  =UPPER(LEFT(C2,1))&MID(LOWER(C2),2,999)

Originally posted by : Amit Oura
If you have a sentence in cell C2  and you want to make only the first word capitals do this  =UPPER(LEFT(C2,1))&MID(LOWER(C2),2,999)

A simpler way to do this is use "=Proper(Cell1)"

 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details