Hi Paul
Presuming your City Column is "B" starting at Row 5 type =RIGHT(B5,2) in"C"
Column.
Regards
Cimjet
"paul" wrote in message
...
I have a file like this

Name Address City State ZIP
Zimmer 221 W 10 ATLANTA, GA 11111

So the CITY field contains both the City and a comma, state

How can I easily go through my 5,000 records and move the State to the
actual STATE field in excel?

thanks