Problem with destination format paste

For my spreadsheet, in which I pull rankings of players from different sources, I wanted to copy the table from the rankings website (pasting with destination formatting) and then use an index/match to find the player's ranking from that table, after which I would paste the result as a value and delete the table. What I've discovered, though, is that the "Name" column text from the source is for some reason not being recognized by the index/match formula
The text I imported shows a player in the format "Name (Team/Bye)", like for example, "Jimmy Graham (NO/7)" . So, being that I have all that data in my table already, I went ahead and in the "lookup value" of the index/match, put "CONCATENATE([@First]," ",[@Last]," (",[@Team],"/",[@Bye]). This, to my eye, made the value in the formula match the value in the imported table exactly. However, this returned #N/A, as if to say it couldn't find that value in the range.
Even stranger now, I found that when I go and manually overwrite the imported name cells with the exact same text as it already has, the formula then works. But I really don't want to do that for every name I import.

How do I fix this?

(in case you need it, this is the formula I have, where the S column is the imported names, and V is the imported ranking: =INDEX($V$11:$V$60,MATCH(CONCATENATE([@First]," ",[@Last]," (",[@Team],"/",[@Bye]),$S$11:$S$60,0)) )

What you are trying to describe, is according your point of view.. so, it we gave answer, that also respective of your eye.

Can you please show us the data.. so that we can think/write according to our point of view..

Yes.. "requesting to uopload sample file with expected output, "

Stripped it down to only what we need to figure this out, with the #N/A still there. Try taking the cell "Calvin Johnson (DET/9)" and actually typing that in and see what happens. The #N/A will turn into a 1 most likely, at least that's what's been happening to me.

PS. for some reason, Excel had me save it as a binary workbook because "there is a formula that exceeds the 8000whatever character limit", even though I have no such formulas. Weird.

Try this...

Formula:

Please Login or Register  to view this content.

* CHAR(160)..

will discuss after your check and confirmation.. and I will give you another solution to Remove All that cahracter..

Ok leafs4life22!

Whenever you copy something from WEB, a   (Non-Breakable Space) was sometime copied with it..
If you check each character's CODE, you can find it..

Copy J1: J141 and paste in WORD.
Now just Find & Replace
Find ^s " Shift 6 & Small letter s"
Replace ("Space")

It will remove all NBSP and now again Copy from Word and paste in Excel..

Ok leafs4life22!

Whenever you copy something from WEB, a   (Non-Breakable Space) was sometime copied with it..
If you check each character's CODE, you can find it..

Copy J1: J141 and paste in WORD.
Now just Find & Replace
Find ^s " Shift 6 & Small letter s"
Replace ("Space")

It will remove all NBSP and now again Copy from Word and paste in Excel..

Thanks for feedback..

BTW, no need to say thanks.. just press the (*) to add reputation,
Thats the actual way to say thanks in this forum..