What about using a formula in column C like this:
=TRIM(SUBSTITUTE(SUBSTITUTE(B1,A1,""),",",""))
filled down as required. You can overwrite column B with column C by
Pastespecial/Values if necessary.

Regards,
Stefi


€žJohnny B€� ezt Ã*rta:

Hey guys, i was wondering if there was a way to make a macro to do the job of
Substitute or concatonates... a marco that would take out Matching Values
from Column B in Column A:
For Example

|Column A | Column B|
| The American Online | The American Online, Bob |
| The American Online | , Bob |

Thanks so much for your help!!

~johnny b