Thread: ALL CAPS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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