+ Reply to Thread
Results 1 to 3 of 3

How to decipher one column contact names and addresses and return each in separate column

  1. #1
    Registered User
    Join Date
    01-02-2015
    Location
    Rye, NY
    MS-Off Ver
    2013
    Posts
    2

    How to decipher one column contact names and addresses and return each in separate column

    I have contact names and their address in one column in Excel 2013 such as below:

    Brian F Broadnax 2001 Brill Rd #H-6 Mobile, AL 36605
    Queeneta Grimes 3901 Michael Blvd, apt 162 Mobile, AL 36605
    Tara W Lee 1560 East Fleetwood Dr. Mobile, AL 36605

    I need a program created like the technology a business card ocr program uses that deciphers each component and places each portion of a business card into the appropriate fields.

    Regards,

    Craig

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Re: How to decipher one column contact names and addresses and return each in separate col

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    01-02-2015
    Location
    Rye, NY
    MS-Off Ver
    2013
    Posts
    2

    Re: How to decipher one column contact names and addresses and return each in separate col

    Here is a sample of what I need attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Match names in two separate column if = then pull info in 3 column
    By Bevg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2013, 08:31 PM
  2. [SOLVED] How to search for text within a column and return a value in a separate column
    By hulayogi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2013, 10:34 PM
  3. [SOLVED] Using relative addresses to call out Excel table column names in SUMIFS formula
    By djgerbec in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-29-2013, 03:43 PM
  4. Replies: 1
    Last Post: 02-25-2013, 02:27 PM
  5. Replies: 3
    Last Post: 04-26-2005, 05:06 AM

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