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

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

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:

Thanks Stefi, the problem with using these formulas is that I cant access the
information that results. When i click on the cell all i see is
"=TRIM(SUBSTITUTE(SUBSTITUTE(B1,A1,""),",","") )" I cannot actually access the
information the resulted.

Thanks for your help,

~johnny b

"Stefi" wrote:

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