Splitting Data from a list

[billykiller05]

I have an address list that each address is in one cell. How can I seperate the address, city, state, and zip when they vary so much? I have included a sample from the list below.

320 PLUS PARK BLVD NASHVILLE TN 37217-1001
806 TWIN CITY AVE SPRINGDALE AR 72764-7083
1415 MURFREESBORO RD NASHVILLE TN 37217
300 WILMOT RD DEERFIELD IL 60015-4600
4325 AMNICOLA HWY CHATTANOOGA TN 37406-1014
2505 WEST PARWAY DRIVE RUSSELLVILLE AR 72801
675 PONCE DE LEON AVE NE ATLANTA GA 30308-1829
2035 N COLLEGE AVE FAYETTEVILLE AR 72703-2613
PO BOX 45009 SALT LAKE CTY UT 84145-0009

[NBVC]

one option:

If Address is in A1:

then in B1:

Please Login or Register  to view this content.

in C1:

Please Login or Register  to view this content.

in D1:

Please Login or Register  to view this content.

in E1:

Please Login or Register  to view this content.

each copied down.

Edit: Noticed that I didn't extract City... revised solution.

[billykiller05]

You guys are the greatest.