Excel

Text case change

Ivan F Moala

Can Do

Visits here

Greatest place to be

Thanks for visiting my site lucky visitor:

This page was last updated on: March 16, 2008

Word has the buttons to change your text to upper, lower, sentence or titles case, BUT Excel dosen't. Below is a routine that will do this for you....just select your range and run the macro. You could make this into an addin or perhaps have it in your personal workbook.

Amendment:

29th April 2003 - made into an Addin

Amendment:

9th June 2003 - Thanks to Mike Leslie for his suggestion about incorporating a “Small Caps” macro published by a Mr. Greg Rivet If you have downloaded this addin then I would suggest this amendment.........thanks Mike.

Amendment:

14th March 2004 - Thanks to PonsyNob where selecting just one cell with a formula changes the formula to text.

Greg Truby - allerted me to the fact that the code below is not the code from the Addin. Thanks guys. Feedback always appreciated!

Download Addin here

You don't need a computer degree to understand these Excel tips! You can, however, take an online college course on Microsoft Word and Excel tips to become a more proficient worker. These days, the latest school supply is a laptop, so staying up on technology is good for you and your children.