Hello,
I am hoping to extract 2 somewhat identical pieces of a data from a string of text. We are holding a contest, and the "Coupon" number is the same as the "employee" #. I have formula to extract 1 set of numbers but how do I do the 2nd.
Here is an example of a string of text: coupon code 11013278 and employee number b017872
This formula extracts =MID(G5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},G5&1234567890)),8) the first # 10054178 how do I get the 2nd? or this EMPLOYEE NUMBER #10054178 COUPON CODE #10313040
The string of text is not always in the same order
Bookmarks