Parsing information

Giganews Newsgroups
Subject: Parsing information
Posted by:  dj1cincy (dj1cincy.289kem_1148393479.715@excelforum-nospam.com)
Date: Tue, 23 May 2006

Is there a way to take a list of names and addresses such as

Chico Nissan Hyundai 575 Manzanita Ave Chico, CA 95926-1322
530-891-1777
Chino Hills Ford 4480 Chino Hills Pkwy Chino, CA 91710-5602
909-393-9331

and create a macro to be able to put the name in one field, street
addresss in another, city in another, state in another, zip in another
, and phone number in another?

Any help would be appreciated

Dan

--
dj1cincy
------------------------------------------------------------------------
dj1cincy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34702
View this thread:http://www.excelforum.com/showthread.php?threadid=544698

Replies