Same question about how to separate address from city
"Ardus Petus" <
[email protected]> a écrit dans le message de news:
%
[email protected]...
> 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" <[email protected]> a écrit
> dans le message de news:
> [email protected]...
>>
>> 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...o&userid=34702
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=544698
>>
>
>
Bookmarks