Trim

[2EZMolson]

hello

Iam pulling hockey stats from yahoo sports into excel on one tab then i have other tabs as teams and iam pulling the stats from the yahoo sports tab to them

the yahoo tab is called Players
but when yahoo bringis in the players names they come with a space in front of them. Now the formula iam using works if i go to the players tab and take the space out but as soon as I refresh the data it puts the space back.

here is what iam using
=IF(ISNUMBER(MATCH(TRIM($D5), Players!$A$1:$A$635,0)),INDEX(Players!NHL_2010_skaters, MATCH(TRIM($D5), Players!$A$1:$A$635,0), MATCH(E$4, Players!$A$1:$AT$1, 0)),0)

can anyone help me I think i have to put trim in by the players but when i try and add it I get formula errors

I attached my file right now I only have one team (killerbeez) but i have to add 9 more teams after i get the formula to work.

[mewingkitty]

can anyone help me I think i have to put trim in by the players but when i try and add it I get formula errors

Why don't you describe what you need to formula to do instead of what you think you should try to accomplish it. I don't see any errors on the page you posted.

Also curious:
IF(ISNUMBER(MATCH(TRIM($D5)...

You can see if you evaluate the formula, that's checking to see if the match is a number. Is this a form of error handling?

Just thinking about this...
If your updated input sheet is always going to have that space at the beginning, you could just run with it and put a space at the front of your entered player names, and drop the trim idea altogether.

[2EZMolson]

I need the formula to Bring the stats from the players tab to the killerbeez tab

I tryed taking out the trim but everytime i try and take it out i get a error iam very new at excel and had alot of help getting the formula. That would work great if i can take the Trim out

=IF(ISNUMBER(MATCH(TRIM($D5), Players!$A$1:$A$635,0)),INDEX(Players!NHL_2010_skaters, MATCH(TRIM($D5), Players!$A$1:$A$635,0), MATCH(E$4, Players!$A$1:$AT$1, 0)),0)

What would i have to take out??

[mewingkitty]

Maybe you missed my meaning there...
See attached sheet.
I've created a macro to add a space in front of all the players names which you have listed on that page (Column D). This allows the formula to work without the trim, this is what I meant when I said "Run with it", as in rather than try to change your input data every time, just change the names of the players to suit the page they'll be referencing.

EDIT:
Since you asked, what you'd take out is the characters listed in red:

Please Login or Register  to view this content.

EDIT EDIT:
Leave the TRIM in for your goalie formulas since the list of goalie names does NOT have spaces, but the ones on your team page now DOES.

[2EZMolson]

Worked thank you so much.