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.

Hi

You could use the Proper Function

i.e. =PROPER(A1)

This will change the first letter to a Capital and the rest to lowe
case

HTH

Davi

--
Message posted from http://www.ExcelForum.com

Hi Alex,

Try =PROPER(B1) and fill down. Copy Edit Paste Special Values to get
rid of the formulas.

HTH
Regards,
Howard

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

Use the "Proper()" function in a macro or in a separate
column which you can then convert to text and paste over
the current column. (Paste special: values)

St County
CO ADAMS
CO LARIMER

But you example doesn't indicate you want "1st letter" when
the text includes "CO" so you will need to run a search and
replace for "Co " perhaps.

--
Herb Martin
"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:

To:
St County
CO Adams
CO Larimer

Thank you.

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.