Any Google Spreadsheet experts?

I'm playing with Google Spreadsheets at the minute, and it appears to be really clever (maybe it's not, maybe Excel is as clever- I just don't use Spreadsheets!)

This is my spreadsheet (it's public, you can edit/play/etc...)

Basically, I want to remove the *'s from the GBHI Data cell's and pull out all of the Sheffield Kings results.

You can see what I mean in the Kings Web Data sheet, but I've bodged that and just pasted the Values.

Surely this must be possible? Any Excel/Google Spreadsheet guru's around?

I don't get your question. Can you please explain?

You will likely need to write some JS

https://developers.google.com/apps-s...articles?csw=1

EDIT: I can't see any 's in the spreadsheet so not sure what the question means.

The best tip I've found with google spreadsheets is not to use em....

Quote:

---

Originally Posted by Alanna

Well i've opened up the sheet but there's no ('s). Don't know that there might be some problem in sheet sharing.

---

Or it might be that the question is 2 and a half years old and the data's changed in the mean time... ;)

Given this thread's been necro'd twice with no useful assistance being offered either time, I'm going to close it to prevent a repeat...