For the sake of the example.
Assume that I sell car parts.
Column A is the part number.
Column B is supposed to be a serial number - but there was no validation on this field and there is all sorts of funny values.
I want to extract potential VALID serial numbers data from column B and put it into column C.
See example in sheet.
A serial number is deemed to be valid if there are 4 (or more) numeric digits in a row.
123456CATS is valid - ie. 123456
123CATS1234 is NOT valid
19090CATS123 is valid - i.e. 19090
It may be easier to follow in the attached sheet.
Objective: Populate column C with valid serial number that are found in column B.