Convert UPPER CASE to Lower Case?

[Newbie]

I have an worksheet that has 2000 names all in upper case. I want to
convert them to "proper" names. I can't figure out how to do it.

The sheet has:
Column A
FIRST MIDDLE LAST

and I want
First Middle Last

For all the rows.

Thanks for your help.

 

[Bob Phillips]

=Proper(A2) in B2 and copy down

 

[Anne Troy]

Try this:
http://www.officearticles.com/excel/change_the_case_of_text_in_cells_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Gord Dibben]

Assuming names are in column A...............

In an adjacent helper column enter =PROPER(A1)

Double-click on the fill handle of that cell to copy down.

When happy, copy>paste special>values>OK>Esc

Delete the original column.


Gord Dibben Excel MVP

 

[David McRitchie]

It could take 3 minutes to use Anne's macro on 600kHz machine if one
chose the entire column. Speed would be greatly improved by
even limiting to the used range. SpecialCells is automatically
limited to the usedrange by definition, but by limiting the cells
processed to TEXT you have even fewer cells to process.

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

I avoid using value so even if someone messes with the procedure
they are still less likely to do damage by using formula rather than
value.

With MS Word your selection would be much smaller but with
Excel processing 65536 cells per column whether you need
to process them or not can take a long time.

In any case a macro solution is best, because you will
process the cells once, in place, and be done with it. There are so
many gyrations involved with using a Worksheet Formula
and then changing the content of the original or replacement
column with capitals that even outside the programming group
I wouldn't really recommend the worksheet solution.

 

[Newbie]

Thank you eveyone! Mission accomplished.

 

[Guest]

Look on http://www.auditexcel.co.za/text.html to see a video clip on how to
use the UPPER, PROPER and LOWER functions.