Separating a column by numbers vs. letters when numbers are at the end of the cells?

I'd like to separate a column based on numbers vs. letters, where the numbers are at the end of the cells. For instance the following lists some Super Bowl scores, and an example score:

New York Giants 1000	New England Patriots -250
Green Bay Packers 31	Pittsburgh Steelers 25
New Orleans Saints 31	Indianapolis Colts 17
Pittsburgh Steelers 27	Arizona Cardinals 23
New York Giants 17	New England Patriots 14
Indianapolis Colts 29	Chicago Bears 17
Baltimore Ravens 34	New York Giants 7

Here there are two columns, one with the winner and the other with the loser. I'd like to separate this into 4 columns - one with the winner's name, the second column with the winner's points, the third column with the loser's name, and the fourth column with the loser's points.

The issues are that the winner/loser names have variable lengths and word counts (some have two words like "Baltimore Ravens", others have three like "New York Giants"), and also the points scored can be an arbitrary number of digits (1 digit, 2 digits, 3 digits, 4 digits, etc.) and in theory can also be negative. So I can't simply use the formula:

=RIGHT(A1,2)

To separate the numerical values, since they might be an arbitrary number of digits. Likewise I can't use the following formula to get the team name:

=LEFT(A1,LEN(A1)-3)

How can I accomplish this task of separating these two columns into four columns, where the numerical values have their own columns? The result I'd like to achieve is four columns that look like this:

New York Giants		1000	New England Patriots	-250
Green Bay Packers	31	Pittsburgh Steelers	25
New Orleans Saints	31	Indianapolis Colts	17
Pittsburgh Steelers	27	Arizona Cardinals	23
New York Giants		17	New England Patriots	14
Indianapolis Colts	29	Chicago Bears		17
Baltimore Ravens	34	New York Giants		7

Hi

This is a way to do this.

For separate the text, use this function.

=LEFT(A1;MATCH(1;ISNUMBER(MID(A1;COLUMN($1:$1);1)*1)*1;0)-1)

Array formula(CSE)

For separate numbers, use this.

=LOOKUP(9^9;1*RIGHT(TRIM(A1);COLUMN($2:$2)))

Hope to helps you.

You are welcome!

So pls, mark your thread, as solved.