Extract Numbers from String

[mattneil41]

Hi there

Hopefully you can help me on the issue below. I have a text string formatted like so:

Team A 2:4 Team B

I want to be able to extract the 2 into Cell A and 4 into Cell B.

Thanks.

[Phuocam]

Team A:

=LOOKUP(10^10,--MID(A1,FIND(":",A1)-{1,2,3,4,5},{1,2,3,4,5}))

Team B:

=LOOKUP(10^10,--MID(A1,FIND(":",A1)+1,{1,2,3,4,5}))

[mattneil41]

Team A:

=LOOKUP(10^10,--MID(A1,FIND(":",A1)-{1,2,3,4,5},{1,2,3,4,5}))

Team B:

=LOOKUP(10^10,--MID(A1,FIND(":",A1)+1,{1,2,3,4,5}))

Brilliant, thank you!