|Unfortunately, I am traveling for the next few days and don't have easy access to Excel. I'm working from an iPad.|
I basically did the same thing as you described, except that I used hundreds of randomly generated strings as my test and it worked fine.
1 - I put this formula in A1 and dragged it down hundreds of rows:
This created strings like 3-6-6-7
2 - I then copied the strings into Notepad and saved the txt file.
3 - Back in Excel, I used the same formula as above but used spaces instead of hyphens to create random strings with spaces, e.g. 3 6 2 9
4 - I selected Column A and did a Copy...PasteSpecial...Values to lock in the strings.
5 - I ran the macro and the code highlighted the "matching" strings.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.