You could use a formula in a column of helper cells:

=proper(a1)

(convert to values and delete the original???)

Mary wrote:

I can not seem to understand the online help, on how to make proper
capitalization column at a time

--

Dave Peterson