Google added a new function called “importRange” into Google Spreadsheets, that’ll import your saved data from a Google Docs spreadsheet into another spreadsheet. Say, you’ve a spreadsheet with following URL:

spreadsheets.google.com/ccc?key=
        pvm6FPiylicLb_2cwmpkHfw&hl=en

….just define a range to make referring to this data easier named “PeopleAges” . In your second spreadsheet, edit a cell and copy the key of above URL as first parameter. The second parameter will be the range name:

=importRange("pvm6FPiylicLb_2cwmpkHfw", "PeopleAges")

….now hit return on the above formula, the second spreadsheet will briefly display a “loading” message and then shows the age data from the other spreadsheet.

German GoogleWatchBlog reports, Google added a split function to split a string into an array, and they now allow you to search and replace in spreadsheets.

Source:→ Google Blogoscoped