ALL CAPS
Maybe you could insert a helper column and use a bunch of formulas like:
=lower(a1)
(and drag down)
or
=proper(a1)
(and drag down)
If you're happy, select this range.
Edit|Copy
Select the original column
edit|Paste special|values
And delete the helper column.
(I'm not sure what regular words are.)
Noncentz303 wrote:
I have a column that I would like to edit in which all of the words are
capitalized. I need to convert them to regular words.... Is there a way I can
fast edit this bad boy.
Example , DENVER to Denver
--
Dave Peterson
|