ALL CAPS

[Guest]

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]

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.)