Hi,

2 ways.

1. Hide the column with the capitalised words in.

or

2. Copy the 'Proper' colmn and paste it back over itself using
Edit|Paste special
paste values
then delete the capitalised column

Mike

"catjea2000" wrote:

is there a way to remove the cells that are still in all caps without losing
the "proper" column?