@JacobJanTuinstra & @VidarS.Ramdal is such equivalent regex support poossible in excel? http://office.microsoft.com/en-us/word-help/find-and-replace-text-by-using-regular-expressions-advanced-HA102350661.aspx
Hmm, I make a lot of stuff using =importHTML (which may also exist in Excel, don't know), which is really cool for integrating with and pulling data from external sources
And that could be almost any source, like a regular website with a table on it
Sports results, for example
Combine that with user input (through Google Forms), and you could actually make a quite capable webapp with just a few lines of code
My friends and I have an annual competition on guessing who wins Premier League. With a spreadsheet and some scripting, I have made a status board which shows who has the closest guess, historic graphs and much more
