1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Extracting contact info into separate columns

Discussion in 'Business Applications' started by assumebusy, Dec 28, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. assumebusy

    assumebusy Thread Starter

    Joined:
    Dec 28, 2011
    Messages:
    1
    I am an excel 2007 user and I'm trying to extract a mixed contact information cell into individual columns to be imported into CRM which include a postal address, phone number, fax number, website and email id for a large worksheet separated by new line characters.

    Sample of the cells to be extracted:
    PO Box 1234, Safat, 12345, Egypt
    Phone - 123 456789
    Fax - 123 456789 http://www.abcd.com E:[email protected]


    Main Building
    Salmiya
    P.O. Box 56789
    Safat 5678, Egypt
    Tel:+567 789-5647
    Fax:+567 8473-3456
    www.xyz.com
    www.uvw.com E:[email protected]
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,732
    A macro would be your best bet but this would be nearly impossible without seeing the actual data since there may be variations between the records

    Rollin
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1033291