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.