I need a function that will move only the last two numbers to column B and remove them from column A. Using the below data I need to separate the names vs the scores. However, some names have numbers and I need the number that is part of the name to remain. Therefore, If I could only separate the last two digits from the name I'd be OK. I need the score to move to column B and keep the name in column A.
Two examples are in Bold. Those teams have a number at the end of their name. I need that to remain with the name.
Evansville North44
LC Titans41
NKE843 (NKE8 = Name & 43=score)
So. IN Elite31
Locust Grove38
Hawks 5A39 (Hawks 5A = Name & 39 = score)
Locust Grover
East Elite 5th38
OC Thunder47
Hawks 5A33
Two examples are in Bold. Those teams have a number at the end of their name. I need that to remain with the name.
Evansville North44
LC Titans41
NKE843 (NKE8 = Name & 43=score)
So. IN Elite31
Locust Grove38
Hawks 5A39 (Hawks 5A = Name & 39 = score)
Locust Grover
East Elite 5th38
OC Thunder47
Hawks 5A33