Extract 8 digit numbers between values in a column using excel functions-CodePudding

I have column which has combination of the values i want, along with the dates

And I want specifically those 8 digit number in next column extracting them alone leaving the dates.

EXPECTED OUTPUT-

Note- the set of values to be extracted is constantly 8 digits and doesn't necessarily have to start with 55.

CodePudding user response：

You can try FILTERXML() like-

=TEXTJOIN(";",TRUE,FILTERXML("<t><s>"&SUBSTITUTE(SUBSTITUTE(A2,"/","</s><s>"),";","</s><s>")&"</s></t>","//s[not(contains(., '.'))]"))