Help with excel spreadsheet

[burrissa]

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

[yak merchant]

Assuming they all have a + or a * it would be..


=LEFT(A1,(MIN(LEN(A1),IFERROR(FIND("+",A 1,1),999),IFERROR(FIND("*",A1,1),999)))-1)

[burrissa]

Thank you Yak that worked great for the * and + but not for the names with just a \. I fumbled my way through adding another Iferror and finding the \ and all names look good now. Once again thank you.

[a4u2fear]

Also look at text to columns command, you can specify what operators to separate if need to do a lot at once

[usma1992]

I would also use the Substitute command to get rid of the spaces...

in your players names. It is much easier to work a name with no spaces. Very easy to do.

Substitute(c4," ","")

Dave

[cincy]

I also download data from pro football ref. I find it easiest to click data, text to column, delimited, check other and enter /, finish