Extract numbers from a text in excel cell

Hi Petra and welcome to the forum

Try this array formula in B1 and copy down. Format cell in column as Number

=NPV(-0.9,,IFERROR((MID(A1,256-COLUMN($1:$65536),1)%),""))


or this one if you using older excel version

=NPV(-0.9,,IF(ISERROR(MID(A1,256-COLUMN($1:$65536),1)%),"",MID(A1,256-COLUMN($1:$65536),1)%))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Row\Col	A	B
1	abcd 8690511191469	8690511191469
2	8690511191308/ABC/D	8690511191308
3	GYTEW/8690511170235	8690511170235
4	abCD//8690511170280/format/deformat	8690511170280
5	country/869051122814/ng	869051122814

=IFERROR(LOOKUP(10^15,MID(A1,SMALL(INDEX(IFERROR(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&0),10^10),0),1),ROW(1:15))+0),"")
try this