Extract only numbers into 2 separate columns

[strongman86]

Hi,

Looking for formula to extract numbers only from single cell containing text and numbers with variable length and can have space or no spaces between and "," or ".". Column A to extract from and B & C column desired result:

	A	B	C
1	Banana 123 Orange 5468	123	5468
2	Lime4587Strawberry711	4587	711
3	Pear 4545 Melon 4487	4545	4487
4	Lemon 65878Grape 54414	65878	54414
5	Orange Tree.9874 Pineapple mix, 51458	9874	51458

Thank you.

 

[JvdV]

Book1
	A	B	C
1	Banana 123 Orange 5468	123	5468
2	Lime4587Strawberry711	4587	711
3	Pear 4545 Melon 4487	4545	4487
4	Lemon 65878Grape 54414	65878	54414
5	Orange Tree.9874 Pineapple mix, 51458	9874	51458
Sheet4

Cell Formulas
Range	Formula
B1:C5	B1	=INDEX(FILTERXML(CONCAT("<t><s>",IFERROR(--MID($A1,ROW(A$1:INDEX(A:A,LEN($A1))),1),"</s><s>"),"</s></t>"),"//s[.*0=0]"),COLUMN(A1))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[strongman86]

Book1
	A	B	C
1	Banana 123 Orange 5468	123	5468
2	Lime4587Strawberry711	4587	711
3	Pear 4545 Melon 4487	4545	4487
4	Lemon 65878Grape 54414	65878	54414
5	Orange Tree.9874 Pineapple mix, 51458	9874	51458
Sheet4

Cell Formulas
Range	Formula
B1:C5	B1	=INDEX(FILTERXML(CONCAT("<t><s>",IFERROR(--MID($A1,ROW(A$1:INDEX(A:A,LEN($A1))),1),"</s><s>"),"</s></t>"),"//s[.*0=0]"),COLUMN(A1))
Press CTRL+SHIFT+ENTER to enter array formulas.

Works perfectly. Much appreciated.