Find a text substring that matches a given "pattern"

[Rick Rothstein]

I am replying to this article to alert anyone subscribed to it that I edited the code in the original article... see the Edit Note in the original article for details.

[aimhigh85]

Rick,

This UDF has already helped me tremendously for the data I am trying to comb through. Being new to all this, can you help guide me through having this look for every instance of the pattern in a cell? This works flawlessly for the first instance of my pattern but some of my data has 3-5 instances of the pattern in a cell and I would like to return all matches separated by a comma if at all possible.