All the functions to merge cells and columns in Google Sheets. Check out formula examples with CONCAT, CONCATENATE, JOIN, TEXTJOIN, SUBSTITUTE and &.
SPLIT is a Google Sheets function to divide data into fragments. Check out how it works, as well as other options to split cells in spreadsheets.
Google Sheets provides plenty of shortcuts to optimize your workflow with spreadsheets. Check out the hotkeys by category and see how they work in action.
COUNTIF lets you count data based on a specific criterion. COUNTIFS works for multiple conditions. Check out the following real-life counting spreadsheet formulas.
QUERY and IMPORTRANGE is a powerful combination that lets you manipulate data when importing it from spreadsheets. Learn the manipulations you can do!
Is Google Sheets Query function difficult to understand? Read this blog post to discover the secrets of the Google Sheets Query function syntax through easy to understand formula descriptions and real examples accessible from a view-only spreadsheet.
Can the IFS function replace nested IF statements used with logical operators AND and OR? Check this out through real formula examples.
IMPORTDATA may not be the best way to fetch CSV data into Google Sheets. Discover Coupler.io, a decent alternative for automating data import.
Review this blog post to learn how to link data between Google Sheets by utilizing different approaches, and pick the one that will suit you the best.