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?