+ Reply to Thread
Results 1 to 2 of 2

Pick street address out of text

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    13

    Pick street address out of text

    Is there a way to pick street addresses out of cells, where no standard format exists. I am attaching an example. Thank you.

    The password is "excelforum.com"
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-07-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Pick street address out of text

    Maybe I can delete everything up to the first number (address), and remove all headings (North East South West). Then will it be possible to remove everything after the word (street name) following the numbers (address)? I can lose the city and zip code if I have to.

+ Reply to Thread

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