I have carriage returns in a column as follows:

address1 CR city CR state CR zip

--and--

address1 CR address2 CR city CR state CR zip

I need the city, state and zip to end up in the same column.

Can you help?

Thanks.

sra
Excel 2003




--