View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny B[_2_] Johnny B[_2_] is offline
external usenet poster
 
Posts: 20
Default Finding info of one column and removing it from another

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