Thank you for replying.

This does not do what I want it to do...
It creates many columns starting with the ZIP), CITY

What I need it to do is to take something like
Newark (94560), East Palo Alto (94303), Fremont (94536), Fremont (94538),
Fremont (94539), Fremont (94555), Hayward (94540), Hayward (94545), Hayward
(94557), Union City (94587)

and turn it into

94560, 94303, 94536, 94538, 94539, 94555, 94540, 94545, 94557, 94587

I have been using word (convert text to table then table to text, text to
table using the ( for the seperator, then cut column, convert to text, then
replace the )^p with a ,

This works, but is cludgy and I need to do this about 40-50 times a day.

I would ideally like to paste in one cell, and then the next cell would have
my desired out put in the next cell.

Thanks,
Bruce



"Adrian#" wrote in message
...
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