Separate numbers from text in string

[Ian McPherson]

Attached file shows number/text string in Col B. I wish to have the two numbers split out as shown in Col A.
Thanking you in advance.

[protonLeah]

Are they always two strings separated by a single space and ending with a single letter?

[Ian McPherson]

Yes, always an S, space and E at the end.

[protonLeah]

Try
=LEFT(B3,FIND("S",B3)-1)
and:
=MID(B3,FIND("S",B3)+2,LEN(B3)-FIND(" ",B3)-1)

[Ian McPherson]

That did the trick. Cheers.