Find in Column A and Remove from Column B

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find in Column A and Remove from Column B 3
Seperating Text from Columns 1
Finding info of one column and removing it from another 9
Finding Info from Column A and Removing it from Column B 2
See Results of Formula rather than the Formula Itself 3
Sum up cells in column A that has same text in Column B. 4
Return MAX value from column B and Name from column A 2
matching columns 4

Back
Top