Change from all CAPS to only the 1st letter

[Alex]

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.

 

[DSC]

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

 

[L. Howard Kittle]

Hi Alex,

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

HTH
Regards,
Howard

 

[Herb Martin]

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.

 

[Don Guillett]

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