Search substring within range, report the substring found

Hi Everyone,

What i have is a single worksheet that has a range from A2 to G30,000 that contains various text and numbers - there is nothing similar, these are random. At the end of this range, in column H, i have a list of strings that i want to search within the A2:G30,000 range. I can find formulas through online searches that can search for any of these sub-strings within a specified range and report either an "X" or some other text when a matching sub-string is found, but what i want to report is the sub-string that was actually found.

Can this be done??

I'm new to the forum and noticed on my post it has listed excel 2003... I'm actually using Excel 2010.. I'll suss out how to fix this, but i wanted to just add this comment to my post if anyone tries to help me in the mean time.

Cheers!