I have data in a column that looks like the following:
John Smith -0.25 1.25
Jason Scott Anderson 1.10
Frank Burns 0.10 1.15
Anna-Sophia Thomas 0.80
George Young N/A
Tom Brady R/U
I need to have the names in a new column without the other data - what's the best way to separate from the other data in the cell? The other data is consistent to the examples I've shown - always 1 or two numbers with 2 decimal places or N/A or R/U.