Hi Please can someone help me.
I have a whole list of serial numbers (H001 to H4569) which I want to find within a multiple text strings.
Example: H2365 ATTEND TO NOT STARTING 384146 REQ, but the serial numbers are either in the beginning, middle or end of the text string.
But the formula also...