Results 1 to 3 of 3

Splitting Data from a list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-26-2006
    Posts
    141

    Splitting Data from a list

    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
    Last edited by billykiller05; 03-31-2009 at 12:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1