Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 13 of 13 · 148 posts
How to Split Text in Excel (Text to Columns, TEXTSPLIT, and More)
Four ways to split text in Excel: Text to Columns wizard, TEXTSPLIT function, LEFT/MID/RIGHT formulas, and Flash Fill. The right method depends on whether you need it to stay live.
How to Use IMPORTRANGE in Google Sheets
IMPORTRANGE pulls data from one Google Sheet into another — live, automatically updated. Here's the syntax, how to grant access, common errors, and how to combine it with other functions.
Google Sheets QUERY Function: SQL for Your Spreadsheet
The QUERY function lets you filter, sort, group, and aggregate data using SQL-like syntax — without pivot tables or complex formulas. Here's how it works with practical examples.
How to Use the FILTER Function in Excel
The FILTER function returns only the rows that meet a condition — live, no manual filtering needed. Here's the syntax, single and multi-condition examples, and how to combine it with SORT.