I'm trying to separate a players name that has addition characters behind it. I'm also trying to get a grasp on index-match formula. Examples below.
This is how the downloaded data from pro-football reference looks like. I can do the Left-Find to eliminate everything from the \ to the right but how do you get rid of the *+ from one name and the * from the other? Do you have to use a name bridge or is there a simple formula to use? I'm trying to learn excel on my own and this is the start of my fantasy projection sheet. Thanks in advance.
Julio Jones*+\JoneJu02 DeAndre Hopkins*\HopkDe00 Jarvis Landry*\LandJa00