Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case of text without using functions?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case of text without using functions?
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 "SimpleIsBest" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change case of text without using functions?
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 On Fri, 20 Jul 2007 05:36:02 -0700, SimpleIsBest wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change text case | Excel Worksheet Functions | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Change case of text | Excel Discussion (Misc queries) | |||
How do I change the case of text | New Users to Excel | |||
How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) |