Other way is described in
http://www.mrexcel.com/td0109.html
using the formula "proper"
--
Greetings from New Zealand
Bill K
"Chip Pearson" wrote in message
...
You could use a VBA macro like the following:
Sub AAA()
Dim Rng As Range
Application.EnableEvents = False
For Each Rng In Range("A1:A100") '<<< CHANGE
Rng.Value = StrConv(Rng.Text, vbProperCase)
Next Rng
Application.EnableEvents = True
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"fastblogs" wrote
in message ...
In My spread sheet I have a list of
names but they are all in caps...
That was great for an envelope but
not so good when I am going to
do a letter merge.
How do you remove or format the
names so they are not all caps?
Can you do that?
Obviously I would still need the first letter
to be capitalized but not the whole name.
Any help would be greatly appreciated, I am stuck
and do not want to type out every name ..
I have excel 2002 and access 2002 and I cant seem
to find out how to change this
Sam
--
fastblogs
------------------------------------------------------------------------
fastblogs's Profile:
http://www.excelforum.com/member.php...o&userid=35118
View this thread:
http://www.excelforum.com/showthread...hreadid=548727