If your data are in columns A & B, put this in column C
=SUBSTITUTE(B3,A3&", ","")
If you want to, you can then copy the result from C and paste special values
if you want to get rid of the original column B.
--
David Biddulph

"Johnny B" wrote in message
...
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