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:http://www.excelforum.com/member.php?action=getinfo&userid=34702
> View this thread:http://www.excelforum.com/showthread.php?threadid=544698

Replies

None

In response to

Parsing information posted by dj1cincy on Tue, 23 May 2006