Change Case button?

[Hiking]

Hello All,

Is there anything like a Change Case button in Excel?

I sometimes need to click on a cell, and change the case of the contents
of the text in the cell.

Ideally, I could click on a cell and then highlight only part of the
cell text and change the case of only the selected text.

I've looked in the Customize window, but don't find such a button,
although I'm fairly certain there is one in MS Word, which is why I'm
hopeful that there may be such a capability in Excel.

Thanks.

 

[Gord Dibben]

Hiking

There is no Change Case button native to Excel.

There are the Functions UPPER, LOWER and PROPER which can be used to affect
whole cells.

e.g. =UPPER(cellref or "string")

You can use VBA macros to to convert a single cell or many cells en masse. If
interested see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/proper.htm

As far as individual characters in a cell, you can always manually edit parts
of a string in a cell.


Gord Dibben Excel MVP