How to change the case in mS excel without using fromulas

I want to change the case , i know all the TEXt formulas - UPPEr LOWER PROPER..

however i want to use it the way we use it in MS Word?

Can only do this with a macro in excel.

Links should help

http://www.cpearson.com/excel/ChangingCase.aspx

http://www.vbaexpress.com/kb/getarticle.php?kb_id=69


VBA Noob

Good morning all4excel

Download and istall my add-in via the link below.
Once installed go to Ultimate > Range > Text Tools and select the Case tab.
You can choose between UPPER CASE, lower case, Proper Case, First letter only, or tOGGLE cASE.

HTH

DominicB