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.