I've been all over trying to find these things out myself, and I've learned a lot in the process, but now I need to resort to help from the community. I've made a list of statistics for characters from a game I play; I need to know two things, and it all pertains to the sheet titled, "import". On the first column under "champions" every name has been duplicated, which I assume has to do something with the hyperlinks on the original page. Second, I need to remove the "+" signs on the numbers under the columns titled "hp+", "hp5+", "mp+" and so on, because spreadsheets thinks that it's the beginning to some sort of code, and I just need the numbers. On the other sheets, I deleted each duplicate name by hand, and the + signs with find and replace, but I'd really like to just have the one sheet so I don't have to redo all of it each time the statistics change within the game. I really appreciate the help of anyone who knows the answers
The link to the spreadsheet https://docs.google.com/spreadsheets/d/1tJEv3AQRDHr3D7TxEQNi049sCNNCKVKzKvjM3ATIH_k/edit#gid=0 The link to the page I got the table from http://leagueoflegends.wikia.com/wiki/Base_champion_statistics -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
