Trying to write amacro to compare text in column A to garbage text in column B

[Big Dawg Dad]

I have a new application at work that is beyond crap! I end up exporting data to Excel to do anything because I trust Excel and do not trust Tririga. I have a column of text such as "abc123" and "abc124" and a column of text that contains "what a piece of crap - abc123 - wow and wow" and "bvcf -yui234 - ouch - ouch - ouch" and on and on for many thousands of data entries. I can do the nested loops in a macro and need to come up with a statement that compares column A with column B to see if data in column A is contained in column B, and if it is, I'll just put a flag like "Yes" in column C. Please let me know if this makes sense to anyone and if anyone can help - PLEASE PLEASE do!

-=BDD=-

[Big Dawg Dad]

Anybody????

[HaHoBe]

Hi, BDD,

from what I read: have you looked up InStr in the VBA help? If s string is found within another the position of the first matching character will be returned, otherwise it would just return 0. Or you use FIND and look at parts of the cells instead of the whole. Third could be the use of Autofilter and flag the hits from there.

...because I trust Excel

I canīt really agree with that from my point of view.

Ciao,
Holger