Harvey

Assuming your column is A.

In an adjacent column enter =PROPER(A1) in a cell and double-click on the
fill handle of that cell to copy the formula down.

Fill handle is the black lump at right bottom corner of the cell.

When happy with results, copy and paste special(in place)valuesOKEsc

You can now delete the original column.

Gord Dibben Excel MVP

On Thu, 16 Dec 2004 19:33:05 -0800, Harvey
wrote:

In a spreadsheet that I made, there is a column with all types of text: all
upper, all lower, proper. It could be a long task to re-type each cell.

I'd like to convert this entire column to all proper. How can this be easily
done?

Thanks in advance for your help.