CAPITAL TO SMALL CASE

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