From time to time you want to get more from your data in Google Sheet. It might be some information you collected from a form or any other spreadsheet with data you wish to work on. Here are some useful functions for common tasks.
1. Return the last row
There is no specific function to return the “last row” – but this hack is working perfectly.
2. Joining text
Useful for all the cases where you have first name and last name in 2 columns and you wish to join them.
="this name " & A1 & “ plus this extra name ” & B1
or if you have cells you wish to merge into one with a certain delimiter:
3. Import any RSS, HTML or CSV data Continue reading