Convert Column Text Values

MonitorOntario · Dec 26, 2003

How can I convert an entire column of capitalized text to proper. How d
I apply the the "proper" formula to the text in the cell

Dave Peterson · Dec 26, 2003

You could use a helper column and put a bunch of formulas like:

=proper(A1)
and drag down the column.

Or you could use a macro:

David McRitchie has sample code at:
http://www.mvps.org/dmcritchie/excel/proper.htm

And if you're new to macros, David has some getstarted instructions:
http://www.mvps.org/dmcritchie/excel/getstarted.htm