Once you get the case the way you like using the PROPER formula copied down,
copy that column and Paste Special(in place)ValueOKEsc.

Delete the original column.


Gord Dibben MS Excel MVP

On Mon, 18 Sep 2006 12:49:02 -0700, Ronnie
wrote:

Thanks! I was trying to put it in an empty cell above, but I added a column
and was able to enter the formula in the cell next to it. And it worked! Then
I copied the formula for all the cells below that needed to be change.