View Single Post
Old 21-07-2018, 18:58   #19
Quote:
Originally Posted by wyffy View Post
Data:
=IMPORTXML(B3;"//div[1]/div[1]/div[@class='meta']")

Nation:
=IMPORTXML(B3;"//div[1]/div[1]/div[1]/a/@title")

Image:
=IMAGE("https://cdn.sofifa.org/players/10/18/" & EXTRAE(A1;(HALLAR("player/"; B3;2))+7;50) & ".png";1)
You are a genius man!! see this


Thanks a lot!!
ggdaris is offline   Reply With Quote