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

Question

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.

So if the number is always followed by the / then use mid() and find() — Solar Mike, Jul 07 '22 at 11:03
@Harun24hr, Can I use this formula in VBA code to auto execute it ? — Lote_marsk_chozey, Jul 07 '22 at 15:58

score 1 · Accepted Answer · answered Jul 07 '22 at 11:09

1

You can try FILTERXML() like-

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

answered Jul 07 '22 at 11:09

Harun24hr

1 Answers1