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.
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)"
CAclubindia
