Extract Email ID From A List Of Sentences

[dunndealpr]

Hey all. I was in this forum a year or so ago when Rick Rothstein saved my life with a VBA code that extracts email addresses from text in Excel files. See http://www.excelfox.com/forum/f2/vba...92/index3.html.

Well, it's been working swimmingly until now. I've found The Cursed File. It's a file of data which Rick's code cannot extract data from no matter what format I save it in.

See the attached file. I created it from scratch, applied Rick's code, and in the top line I pasted a line of data from The Cursed File. As you can see, the code does not extract the email.
Underneath, I created test data. As you can see, the code works.
On the final line, I pasted in some similar data from another file. Code works.

What gives? I've noticed that when I delete about two-thirds of the text from the Cursed Data line in D1, the code works. But that's no fix at all.


Thanks much in advance.