Extract numbers either side of text

[I_AM]

Hello.
I wish to extract a variable sized number from either side of text
Assuming the following is in D1,
10 vs 25 I wish to extract 10 to one cell, 25 to another
1 vs 125 I wish to extract 1 to one cell, 125 to another
0 vs 2 I wish to extract 0 to one cell, 2 to another
All with a single formula.
Extracting with
=LEFT(D1, FIND(CHAR(32), D1)-0)+0 works well with LEFT, not so using the same with RIGHT.

The numbers extracted I wish to add using:
=SUMIFS(A1:A10,B1:B10,C1)
The result of =LEFT(D1, FIND(CHAR(32), D1)-0)+0 are added, yet the results of =LEFT(D1, FIND(CHAR(32), D1)-0) are not?

I think I'm after everything LEFT of the first CHAR(32) and everything RIGHT of the second CHAR(32)?

Thank you.

 

[JoeMo]

Not sure I understand what you want to be "All with a single formula".
Is this of any use?

Book1
	A	B	C	D
1	10	25		10 vs 25
2	1	125		1 vs 125
3	0	2		0 vs 2
Sheet1

Cell Formulas
Range	Formula
A1:A3	A1	=LEFT(D1,SEARCH("vs",D1)-1)+0
B1:B3	B1	=MID(D1,SEARCH("vs",D1)+3,LEN(D1))+0

 

[I_AM]

Not sure I understand what you want to be "All with a single formula".
Is this of any use?

Book1
	A	B	C	D
1	10	25		10 vs 25
2	1	125		1 vs 125
3	0	2		0 vs 2
Sheet1

Cell Formulas
Range	Formula
A1:A3	A1	=LEFT(D1,SEARCH("vs",D1)-1)+0
B1:B3	B1	=MID(D1,SEARCH("vs",D1)+3,LEN(D1))+0

Perfect. Thank you.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 365 you could also use

Fluff.xlsm
	A	B	C	D
1	10	25		10 vs 25
2	1	125		1 vs 125
3	0	2		0 vs 2
Main

Cell Formulas
Range	Formula
A1:B3	A1	=--TEXTSPLIT(D1,"vs")
Dynamic array formulas.

 

[JoeMo]

Perfect. Thank you.

You are welcome- thanks for the reply.