Changing the format of a column

[Guest]

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?

 

[Guest]

use the =proper() function in the next column

 

[Gord Dibben]

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