Looping Through String Using Excel VBA!

[snb]

Did you look at the attachment ?

[Jdean]

Did you look at the attachment ?

Yes, and I am confused. It doesn't look like what I am looking for.
Using text to columns is equivalent to splitting each string into an array with the delimiter "," using the split() function. I executed your code and it still confuses me.

The task I am trying to solve is: I have two strings. I need a quick way to find how many tokens or numbers they have in common.