Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Search Search
Search for:
Tech Support Guy > > >

Extracting contact info into separate columns


(!)

assumebusy's Avatar
assumebusy assumebusy is offline
Junior Member with 1 posts.
THREAD STARTER
 
Join Date: Dec 2011
Experience: Intermediate
28-Dec-2011, 07:18 AM #1
Question Extracting contact info into separate columns
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:info@abcd.com


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:info@xyz.com
Rollin_Again's Avatar
Member with 4,693 posts.
 
Join Date: Sep 2003
Location: Atlanta, GA - Planet Earth
Experience: Advanced
28-Dec-2011, 09:18 AM #2
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


Tags
addresses, column, excel, extract

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑