Excel 2000:

I'm trying to split the city state zip field into individual fields. I was
able to get the zip and state by using the folllowing formulas:

State: =LEFT(RIGHT(M2,10),3)

Zip: =RIGHT(M2,5)

But, I can't seem to get the city. The problem being no comma betwee the
city and St and cities with two name:

Loris SC 29573
Myrtle Beach SC 29577
Little River SC 29588

Any help will be appreciated.


Pete Provencher