Looping Through String Using Excel VBA!

[snb]

Where do those strings reside ? ( in cells, in ranges, txt-files, clipboard, somewhere else..)
Why is this an Excel question in your opinion ?

[Jdean]

Where do those strings reside ? ( in cells, in ranges, txt-files, clipboard, somewhere else..)
Why is this an Excel question in your opinion ?

The strings reside in XL Ranges ("A:A") and ("B:B"). So String A and B (or S1 and S2) are just a comparison of two cell values - one from each column range.
My current approach has been to load both into separate vectors (or 1D arrays), iterate each slot, break each slot into tokens and use two For-Loops to check and count common tokens. This is what the Admin suggested two other methods for checking two strings.