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...o&userid=34702
View this thread: http://www.excelforum.com/showthread...hreadid=544698