in addition to using proper you could use
for each c in selection
c.value=ucase(left(c,1))&right(len(c)-1)
next

--
Don Guillett
SalesAid Software

"Alex" wrote in message
...
I am working on old IRS county migration data. How would
I take all capital letters in a text cell and change it to
a county with only the first letter capitalized. I don't
really know if this a programming question or a worksheet
functions question. Either way, please help. I know it
would easy to do by hand if I only had a few cells, but I
have hundreds.

For example:
From:
St County
CO ADAMS
CO LARIMER

To:
St County
CO Adams
CO Larimer

Thank you.