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?
--
Shelly Johnson
Remax Associates
210-410-2700 cell

in vba:

StrConv(myString,vbProperCase)

in formula:

=PROPER(A2)


that help?


--
medicenpringles


------------------------------------------------------------------------
medicenpringles's Profile: http://www.excelforum.com/member.php...o&userid=16458
View this thread: http://www.excelforum.com/showthread...hreadid=492453

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

On Sat, 10 Dec 2005 12:24:01 -0800, "shelly johnson"
wrote:

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?