Re: Parsing information

Giganews Newsgroups
Subject: Re: Parsing information
Posted by:  Ardus Petus (ardus.pet…@laposte.net)
Date: Tue, 23 May 2006

According to your example, can we assume street address alwauys start with a
number?

If not, how to separate name from address ?

Cheers
--
AP

"dj1cincy" <dj1cincy.289kem_1148393479.715@excelforum-nospam.com> a écrit
dans le message de news:
dj1cincy.289kem_1148393479.715@excelforum-nospam.com...
>
> 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

In response to

Parsing information posted by dj1cincy on Tue, 23 May 2006