Results 1 to 5 of 5

Parsing an Address Without a Comma

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    O 365
    Posts
    80

    Parsing an Address Without a Comma

    Please help
    I'm trying to parse out addresses that do NOT contain a Comma or any other type of delimiter in the address.

    I've attached an example workbook. Column A contains the full address that I need parsed out.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Parsing an address
    By mattmc419 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-22-2015, 01:15 PM
  2. [SOLVED] Parsing comma separated data then counting/summing
    By jmad6 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 04-21-2015, 05:38 PM
  3. Address Parsing
    By bpiereder in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-22-2014, 09:17 AM
  4. Address parsing
    By aus10fek in forum Excel General
    Replies: 14
    Last Post: 01-13-2014, 02:15 AM
  5. Problem with TextToColumns parsing comma, overwriting column
    By ebrary_steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2011, 10:17 PM
  6. parsing comma-deliminated data into multiple columns
    By more_Qs_than_As in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2007, 08:59 PM

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