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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.