copy column 2 to column a on a new worksheet, choose Text to Columns from the
Data menu/gallery depending on version of excel - choose delimited, by
commas, general and your data should then look exactly how you want it.
have fun!

"Johnny B" wrote:

My question may be difficult to understand. Here is my situation: I have two
columns (ex: column 1 and column 2). Column 1 has information repeated in
column 2. I would like to
identify info from column 1 and remove it from column 2.
For example

Column 1 | Column 2
|
American Online | American Online, 1234 USA street |
AMD Anthlon | AMD Anthlon, Customer Support |

I would like it to identify American Online, and AMD anthlon from Column 1
and remove it from Column 2... Giving me:

Column 1 | Column 2 |
American Online | 1234 USA street |
AMD Anthlon | Customer Support |

I would really appreciate if anyone could help me out with this problem.
Thank you very much for your time.

~Johnny B