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.

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

On Fri, 04 Feb 2005 12:39:32 -0500, Hiking
wrote:

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.