Change from all CAPS to only the 1st letter

A

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

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

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
 
H

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
Click to expand...

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

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
 
Top