Merge/Split – Sometimes you have to either merge cells together or split them into multiple cells. For example, in Google Fusion Tables, the whole address (street, city, state, zip) must be in one cell.
Trim – This forumula will remove extra spaces from cells. You don’t want to delete them all one at a time!
Change case – Sometimes data comes in ALL CAPS. You can change it so it is more usable and readable.
Copy – You can copy and paste either contents, values or formulas by using “Paste Special” option.