Extract text strings

Originally Posted by snb

I can't detect a connection between herefs in column A and URL in column B.

Well, the data has been obviously altered to keep it confidential....but a great way to get an example of what I am referring to is to take the sample text and repeat it several times (so you have triple the rows...with the data repeating). I'll give this code a run...thanks for the help! I'll post a response shortly....