Hi

Select the column and click the Data menu and select "Text to Columns...".
This allows you to use the text wizard to separate data in a column into
many columns. Use the delimited option and enter the ( in other as the
separator. This will separte the City from the zipcode. Repeat the process
for the new column with zipcode and closing bracket to remove the ). You
should then have one column with the City and another column with the
zipcode. You could now use a couple of different methods to concatenate the
two columns back together and have a , as the separator. Hope this helps.
Adrian #

"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