This is a follow up to an earlier question (and solution).
I was provided with a function getpartnum which found any 4 (or more) consecutive digits in any one cell. Note the result of this in column "D" of my sheet.
I need to extend the logic to find a second series of 4 (or more) consecutive digits.
So for example,
S/n12344 PP12314 - This should find answers in 2 separate cells - 12344 12314
See examples in column "E".
The existing function simply finds the FIRST occurrence of 4 or much digits.
How do I find a second series of 4 (or more) digits.
The first and second series MUST be separated by any character other than 0-9.