How to change case of text without using functions?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 2003 I could select one or more cells, then right click and select
'Change Case' and then choose to make the text in them all either 'UPPER
CASE', 'Proper Case' or 'lower case' as I wished.
Unless I have overlooked it, that option seems to have disappeared in Excel
2007. The only entries I can find in the Help system relate to using
functions, but I just want a simple menu option.... Any ideas?
 
Hi,

I suspect you had an addin in Excel 2003 that allowed you to do that because
it's not standard functionality. Maybe you could add the addin in to 2007.

Mike
 
That was never an option in any version of Excel.

Your "Change Case" option would have been added to the right-click menu by VBA
and the choices would also have been VBA, probably a UserForm with macros.

See if you can find the add-in or whatever held the code and load it in Excel
2007.

Chip Pearson has a CaseConvert Add-in download that does just that.

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


Gord Dibben MS Excel MVP
 
The best Excel Change Case Add-In can be found at the following link

http://www.nucleation.in/2012/07/change-case-excel-add-in.html

In this add in, change case functionality is incorporated to the context menu, which makes it very easy to use.

This Add-In has the following features
a. Change case of selected cells to ‘UPPER CASE’
b. Change case of selected cells to ‘lower case’
c. Change case of selected cells to ‘Proper Case’
d. Change case of selected cells to ‘Sentence case’
e. Change case of selected cells to ‘tOgGlE cAsE’
f. Customizable shortcut keys to perform change case actions
 
Back
Top