Hello again,
Attached is the file I'm working with. I'm looking to extract a baseball player's name from a string of text in the input cell using a formula if possible.
In the file:
- Column A: The input data - text is always in this format.
- Column B: I used a series of nested IF(LEFT) statements to extract these numbers.
- Column C: Desired output (manually entered for now as an example).
Is there a single formula that would be able to do this? If not, hopefully we can extract the first name to one helper cell and the last name to another helper cell and then it's easy to put them back together again in another cell. Thanks for the help!
Best regards,
Eric
Bookmarks