insert a column to the right of the column you're wanting to change. In the first cell of the new column, enter this:

=PROPER(cell) (cell = the first cell of the column to change)

Copy the formula down, and it will change the first letter of each word to upper case, and the rest to lower.

Hide the original column and you should be good to go!