Capitalization

[Guest]

I have an existing database that is ALL CAPS for the first & last names. I
would like to just capitalize the First letter of each name. How do I do
that?

 

[medicenpringles]

in vba:

StrConv(myString,vbProperCase)

in formula:

=PROPER(A2)


that help?

 

[Gord Dibben]

Shelly

This can be done through the use of the PROPER Function.

SHELLY JOHNSON in A1

In B1 enter =PROPER(A1) to return Shelly Johnson

If you have name like SHELLY MACDONALD the PROPER function will return Shelly
Macdonald which is not correct. but Excel has its limitations.

To really do it up right you need a macro.

David McRitchie has such code that deals with Mc, Mac, deBeers and other
anomalies at his site.

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


Gord Dibben Excel MVP