RE: Parsing information

Giganews Newsgroups
Subject: RE: Parsing information
Posted by:  Michael
Date: Tue, 23 May 2006

dj1cicy, like Shiela D suggested you could use Date-Text to Columns with
space as the separator.  Next, you could use helper columns with the
Concatenate function to recombine the auto dealers name and the street
address.  HTH

Sincerely, Michael Colvin

"dj1cincy" wrote:

> 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:
> View this thread:



In response to

Parsing information posted by dj1cincy on Tue, 23 May 2006