Sign up, and you'll be able to customize your font size and more! Sign up
Jul 1, 2020
10:23:54pm
Biyamiti All-American
Excel question
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.
This message has been modified
Originally posted on Jul 1, 2020 at 10:23:54pm
Message modified by Biyamiti on Jul 1, 2020 at 10:26:39pm
Biyamiti
Previous username
skywalker251
Bio page
Biyamiti
Joined
Mar 1, 2006
Last login
Apr 24, 2024
Total posts
7,148 (49 FO)
Messages
Author
Time

Posting on CougarBoard

In order to post, you will need to either sign up or log in.