I have a column of names listed in capital letters. I would like to change
them so they are written correctly, i.e. JOHN DOE -- John Doe.

Is there anyway that I can creat an input mask for the cells that will
change the names to the format I want?

use the =proper() function in the next column

"MEAD5432" wrote:

I have a column of names listed in capital letters. I would like to change
them so they are written correctly, i.e. JOHN DOE -- John Doe.

Is there anyway that I can creat an input mask for the cells that will
change the names to the format I want?

For current data you can use the PROPER function as dlw points out.

OR you can use a macro to convert all at once in place without a foany formulas.

For new data entries you can use event code to produce what you want as you type
and enter.

Post back if you want either of the latter two.


Gord Dibben MS Excel MVP


On Tue, 15 May 2007 08:19:00 -0700, MEAD5432
wrote:

I have a column of names listed in capital letters. I would like to change
them so they are written correctly, i.e. JOHN DOE -- John Doe.

Is there anyway that I can creat an input mask for the cells that will
change the names to the format I want?