Extract 8 digit number starting with a 4

[Adapt375]

Hi,
Within an excel string containing numbers and alphabets , how do I extract a specific 8 digit no starting with a 4.
Where there are multiple 8 digit nos starting with a 4 , can a message like "check nos" be shown
Thanks

 

[KOKOSEK]

Could You shows some examples of these strings, please?

 

[Adapt375]

I THS, ORT, SM & NE, QUOTE: 2035088337. SMAT FRUT MEDM, REF: 7107588720 ; 41046772 ;

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(s,TEXTSPLIT(A2," "),FILTER(s,(LEN(s)=8)*(LEFT(s)="4"),"none"))

 

[bebo021999]

For Excel version older than 365

Book1
	A	B
1	I THS, ORT, SM & NE, QUOTE: 2035088337. SMAT FRUT MEDM, REF: 7107588720 ; 41046772 ;	41046772
Sheet1

Cell Formulas
Range	Formula
B1	B1	=AGGREGATE(14,6,MID(A1,ROW(INDIRECT("1:" & LEN(A1))),8)/((MID(A1,ROW(INDIRECT("1:" & LEN(A1))),8)-40000000>=0)*(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),8)-49999999<=0)),1)

 

[Adapt375]

Thanks so much for the reply.
Works a treat.

 

[Fluff]

Did the formula I suggested work?