Convert UPPER CASE to Lower Case?

N

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

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top