Converting capitalized text to lower case

[Evie]

Is it possible (if so, how?) to convert capitalized text
to lowercase within cells - - when they were typed in ALL
CAPS mode at the onset?

If you've got a solution to this one, I'll really be
impressed! =)

Evie

 

[Bob Phillips]

VBA?

For Each cell In Selection
cell.Value = LCase(cell.Value)
Next cell

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Evie]

Thanks, Bob. In case you're interested, before I received
your much more efficient solution, I did my usual
little "jerry-rigging" and COPY/PASTED my data into
MSWord. From there, I selected Format and Title Case to
convert the content. I then COPY/PASTED my data back into
my spreadsheet.

It's kinda cheating, but it works. =) It's a shame that
command is not (easily, anyway) available in Excel!

Thanks again for your help! I really appreciate the quick
response.

Evie

 

[David McRitchie]

Hi Evie,
And what if you had formulas within your range. I would
suggest using a macro and something a bit more complete
so that you don't waste time converting empty cells in a
selection, and so you avoid formulas, and turn off screen
updating and calculation while running the macro. You would
be able to run the macro faster than you can paste it into a
word document.

http://www.mvps.org/dmcritchie/excel/proper.htm#lower

Another macro at the top of the page will convert to proper case,
which you'd want to use from names and addresses.

 

[Lady Layla]

Check out functions LOWER UPPER and PROPER in Excel Help


: Is it possible (if so, how?) to convert capitalized text
: to lowercase within cells - - when they were typed in ALL
: CAPS mode at the onset?
:
: If you've got a solution to this one, I'll really be
: impressed! =)
:
: Evie
:
: