Rest of solution:

After you've got the column of zips in Excel, copy & paste it into Word as
plain text, then use Find/Replace to change the paragraph marks (^p) to
commas.

Cheers

--
macropod
[MVP - Microsoft Word]


"macropod" wrote in message
...
Hi Bruce,

Try Data|Text to Columns|Delimited, with the '(' as the separator. That
will
put the zips into a separate column and delete the '('. Then all you need
to
do is to use Find/Replace to delete all the ')' characters.

Cheers

--
macropod
[MVP - Microsoft Word]


"Bruce" <oleexpres.at.johnsonclan.net wrote in message
...
I have strings that are in Column A. These strings are composed of
cities
and zip codes sample is below:
Castro Valley (94546), Castro Valley (94552), Danville (94526), Fremont
(94555), Hayward (94540), Hayward (94545), Hayward (94557), Oakland
(94601),
San Leandro (94577), San Leandro (94578), San Lorenzo (94580), San Ramon
(94582), San Ramon (94583), Union City (94587)

These can be various length of differant city/zip combos

I need to get a list of ZIPS seperated by a comma.

How can I do this/

Thanks
Bruce