Find in Column A and Remove from Column B

[Johnny B]

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

 

[Stefi]

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:

 

[Stefi]

This happens when the cell is formatted as text. Re-format it as general,
click on the formula bar and confirm the formula (press Enter)!
Regards,
Stefi


„Johnny B†ezt írta: