How-to library
Google Sheets tutorials
188 step-by-step walkthroughs covering combo formulas, error fixes, and the patterns that come up over and over in real spreadsheets.
ARRAYFORMULA patterns · 20
- ARRAYFORMULA with VLOOKUP in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with IF in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with IFS in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with SUMIFS in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with COUNTIFS in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with SUBSTITUTE in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with TRIM in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with LEFT in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with RIGHT in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with MID in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with REGEXEXTRACT in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with REGEXMATCH in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with TEXT in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with SPLIT in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with LEN in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with PROPER in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with LOWER in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with UPPER in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with CONCATENATE in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
- ARRAYFORMULA with TEXTJOIN in Google Sheets ARRAYFORMULA is the secret weapon that turns a one-cell formula into a whole-column formula. This tutorial walks through…
Counting & conditional aggregation · 12
- Count with one condition in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countifs multiple criteria in Google Sheets COUNTIFS answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countif with wildcards in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countifs by date range in Google Sheets COUNTIFS answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countif or logic in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countifs with arrayformula in Google Sheets COUNTIFS answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countif not equal to in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Count blank cells with countblank vs countif in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countifs across multiple sheets in Google Sheets COUNTIFS answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Count unique values with countunique in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countifs greater than and less than in Google Sheets COUNTIFS answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
- Countif text contains substring in Google Sheets COUNTIF answers a question every analyst needs to answer constantly: how many rows match these conditions? This tutorial…
Data validation & dropdowns · 8
- Dynamic dropdown list driven by a formula — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Dependent (cascading) dropdowns with INDIRECT — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Dropdown from a unique deduped list — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Dropdown options filtered by another cell — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Multi-level dependent dropdowns in Google Sheets — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Dropdown driven by a named range — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Building a searchable dropdown without scripts — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
- Data validation: reject input vs show warning — formula tutorial Dynamic dropdown lists are one of the highest-leverage things you can build in Google Sheets — they keep…
Date & time · 15
- Calculate age in years from a birth date — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Days between two dates in Google Sheets — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Business days (NETWORKDAYS) between two dates — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Add business days to a date with WORKDAY — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Days remaining until a deadline — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Calculate fiscal year from a date — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Get the calendar quarter from a date — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Get the last day of the month with EOMONTH — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Get the first day of the month from any date — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Classify invoices into ageing buckets (30/60/90) — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Time elapsed since a timestamp — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Duration between two times in HH:MM:SS — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Count Mondays in a date range — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Next business day from today — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
- Date difference in whole months with DATEDIF — formula tutorial Date math is one of the areas where Google Sheets is genuinely better than most calculators: a date…
Error handling · 8
- Fix #N/A error in VLOOKUP and other lookups #N/A is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #REF! error in Google Sheets #REF! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #VALUE! error in Google Sheets #VALUE! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #NAME? error in Google Sheets #NAME? is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #DIV/0! error in Google Sheets #DIV/0! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #NUM! error in Google Sheets #NUM! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix #NULL! error in Google Sheets #NULL! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
- Fix generic #ERROR! in Google Sheets #ERROR! is one of the most common errors in Google Sheets. This tutorial explains exactly what causes it,…
Filter & sort · 11
- FILTER with multiple AND criteria — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER with OR logic between conditions — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER by date range in Google Sheets — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER with REGEXMATCH for fuzzy text matches — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER non-empty rows from a range — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER then SORT the result in one formula — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- FILTER plus UNIQUE for distinct survivors — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- Handle FILTER's "no matches" gracefully — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- SORT then FILTER pattern — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- Top-N rows with SORTN in Google Sheets — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
- Unique combinations across multiple columns — formula walkthrough FILTER returns the subset of rows that satisfy one or more conditions. It is the most natural way…
Google Sheets-specific · 6
- IMPORTRANGE — pulling data between Google Sheets files IMPORTRANGE is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
- GOOGLEFINANCE — pulling stock and currency data into Sheets GOOGLEFINANCE is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
- IMPORTHTML — scraping tables and lists from web pages IMPORTHTML is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
- IMPORTXML — XPath-based scraping in Google Sheets IMPORTXML is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
- IMPORTDATA — pulling CSV and TSV files from URLs IMPORTDATA is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
- IMPORTFEED — bringing RSS/Atom feeds into Sheets IMPORTFEED is a Google-Sheets-specific function that does not exist in Excel — which is exactly why people end…
How-to & common tasks · 20
- Remove duplicates with UNIQUE in Google Sheets Removing duplicate rows is a constant chore in spreadsheets, and Google Sheets gives you several ways to do…
- Find duplicates with COUNTIF in Google Sheets Sometimes you do not want to remove duplicates — you want to find them so you can investigate.…
- Transpose rows to columns with a formula Flipping data from rows to columns (or back) is a one-line formula in Google Sheets thanks to the…
- Running total with a single formula A running total (cumulative sum) keeps a running balance down a column. This tutorial walks through the simplest,…
- Percent change formula in Google Sheets Percent change between two values is the foundation of every growth metric. This tutorial walks through the simplest,…
- Weighted average formula in Google Sheets A weighted average gives different observations different importance — exam scores by credit hours, prices by quantities sold.…
- Rank items with ties handled correctly Default RANK gives tied items the same rank but skips the next one. Sometimes you want dense ranking…
- Highlight the maximum value in a range For dashboards, marking the maximum value in a range with a flag column makes it easy for the…
- Compound Annual Growth Rate (CAGR) formula CAGR turns the growth between a start value and an end value into a per-year percentage. This tutorial…
- Currency conversion with GOOGLEFINANCE Converting between currencies live without leaving the sheet is one of the simpler GOOGLEFINANCE recipes. This tutorial walks…
- Time-tracking duration formula in Google Sheets Subtracting a start time from an end time gives you a duration, but the formatting trips people up.…
- Unpivot wide data into long format with FLATTEN Wide data (months across columns) often needs to become long data (one row per month) for downstream pivot…
- Reverse the order of a column with a formula Reversing the order of a list without sorting is occasionally exactly what you need. This tutorial walks through…
- Pick a random sample of rows in Google Sheets Sometimes you need a random N rows from a larger table for spot-checks. This tutorial walks through the…
- Unique values with their count in Google Sheets A list of unique values plus how many times each appears is the building block of every category…
- Build a dynamic chart range that grows with data Charts pointed at A2:A100 stop updating when row 101 arrives. A formula-driven range solves it. This tutorial walks…
- Find the first non-empty cell in a column Returning the first populated value in a sparse column is useful for staging cells in templates. This tutorial…
- Find the last non-empty cell in a column The mirror image: the last value in a column that is actively being appended to. This tutorial walks…
- Split text into columns with the SPLIT formula SPLIT does the same thing as Data → Split text to columns, but as a live formula. This…
- Flatten multiple columns into one with FLATTEN Combining several columns into a single long column is FLATTEN's specialty. This tutorial walks through the simplest, most…
In-cell visualization · 4
- Line sparkline tutorial in Google Sheets SPARKLINE renders a small in-cell chart from a range of values — a line visualization that fits inside…
- Bar sparkline tutorial in Google Sheets SPARKLINE renders a small in-cell chart from a range of values — a bar visualization that fits inside…
- Column sparkline tutorial in Google Sheets SPARKLINE renders a small in-cell chart from a range of values — a column visualization that fits inside…
- Win/loss sparkline tutorial in Google Sheets SPARKLINE renders a small in-cell chart from a range of values — a winloss visualization that fits inside…
Lookup combinations · 22
- VLOOKUP with IF in Google Sheets Pairing VLOOKUP with IF is one of the most common combinations in Google Sheets. On its own, VLOOKUP…
- VLOOKUP with IFERROR in Google Sheets Pairing VLOOKUP with IFERROR is one of the most common combinations in Google Sheets. On its own, VLOOKUP…
- VLOOKUP with IFNA in Google Sheets Pairing VLOOKUP with IFNA is one of the most common combinations in Google Sheets. On its own, VLOOKUP…
- VLOOKUP with ISNA in Google Sheets Pairing VLOOKUP with ISNA is one of the most common combinations in Google Sheets. On its own, VLOOKUP…
- VLOOKUP with ARRAYFORMULA in Google Sheets Pairing VLOOKUP with ARRAYFORMULA is one of the most common combinations in Google Sheets. On its own, VLOOKUP…
- XLOOKUP with IF in Google Sheets Pairing XLOOKUP with IF is one of the most common combinations in Google Sheets. On its own, XLOOKUP…
- XLOOKUP with IFERROR in Google Sheets Pairing XLOOKUP with IFERROR is one of the most common combinations in Google Sheets. On its own, XLOOKUP…
- XLOOKUP with IFNA in Google Sheets Pairing XLOOKUP with IFNA is one of the most common combinations in Google Sheets. On its own, XLOOKUP…
- HLOOKUP with IFERROR in Google Sheets Pairing HLOOKUP with IFERROR is one of the most common combinations in Google Sheets. On its own, HLOOKUP…
- HLOOKUP with IF in Google Sheets Pairing HLOOKUP with IF is one of the most common combinations in Google Sheets. On its own, HLOOKUP…
- INDEX with MATCH in Google Sheets Pairing INDEX with MATCH is one of the most common combinations in Google Sheets. On its own, INDEX…
- INDEX with IF in Google Sheets Pairing INDEX with IF is one of the most common combinations in Google Sheets. On its own, INDEX…
- INDEX with IFERROR in Google Sheets Pairing INDEX with IFERROR is one of the most common combinations in Google Sheets. On its own, INDEX…
- LOOKUP with IF in Google Sheets Pairing LOOKUP with IF is one of the most common combinations in Google Sheets. On its own, LOOKUP…
- LOOKUP with IFERROR in Google Sheets Pairing LOOKUP with IFERROR is one of the most common combinations in Google Sheets. On its own, LOOKUP…
- VLOOKUP with multiple criteria in Google Sheets VLOOKUP only matches against a single column out of the box, but real lookups often need to match…
- XLOOKUP with multiple criteria in Google Sheets XLOOKUP only matches against a single column out of the box, but real lookups often need to match…
- INDEX with multiple criteria in Google Sheets INDEX only matches against a single column out of the box, but real lookups often need to match…
- HLOOKUP with multiple criteria in Google Sheets HLOOKUP only matches against a single column out of the box, but real lookups often need to match…
- LOOKUP with multiple criteria in Google Sheets LOOKUP only matches against a single column out of the box, but real lookups often need to match…
- INDEX/MATCH with multiple criteria — full walkthrough INDEX only matches against a single column out of the box, but real lookups often need to match…
- XLOOKUP vs VLOOKUP in Google Sheets — when to use which XLOOKUP only matches against a single column out of the box, but real lookups often need to match…
QUERY function · 19
- Google Sheets QUERY: the SELECT clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the SELECT clause is one of…
- Google Sheets QUERY: the WHERE clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the WHERE clause is one of…
- Google Sheets QUERY: the GROUP BY clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the GROUP BY clause is one…
- Google Sheets QUERY: the ORDER BY clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the ORDER BY clause is one…
- Google Sheets QUERY: the LIMIT clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the LIMIT clause is one of…
- Google Sheets QUERY: the OFFSET clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the OFFSET clause is one of…
- Google Sheets QUERY: the LABEL clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the LABEL clause is one of…
- Google Sheets QUERY: the FORMAT clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the FORMAT clause is one of…
- Google Sheets QUERY: the PIVOT clause Google Sheets QUERY turns any range into a tiny SQL-style database, and the PIVOT clause is one of…
- Combining QUERY with IMPORTRANGE for cross-file reporting in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY with multiple WHERE conditions (AND/OR) in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY with date comparisons in Google Sheets in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY WHERE LIKE for pattern matching in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY across multiple stacked sheets in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY PIVOT vs built-in Pivot Table in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- When (not) to wrap QUERY in ARRAYFORMULA in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- QUERY for conditional sums and counts (replacing SUMIFS) in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- Running totals with QUERY in Google Sheets in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
- Handling headers and the headers argument in QUERY in Google Sheets Google Sheets QUERY turns any range into a tiny SQL-style database, and the general clause is one of…
Sums & conditional aggregation · 12
- Sumif with one condition in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs multiple criteria in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumif with wildcards in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs by date range in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumif or logic in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs with arrayformula in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumif not equal to in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs greater than threshold in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumif across multiple columns in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs with text contains in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Running total with sumif in Google Sheets SUMIF adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
- Sumifs month over month comparison in Google Sheets SUMIFS adds up the cells in a range that satisfy a condition. The single-criterion form is genuinely simple;…
Text manipulation · 31
- Extract email addresses from a free-form text column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract and normalize phone numbers in a column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract the domain from a URL in Google Sheets (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Pull numbers out of a mixed text column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract the first name from a full-name column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract the last name from a full-name column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract text between two delimiters in Google Sheets (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract everything after a delimiter character (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract everything before a delimiter character (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract hashtags from a notes column (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Extract every URL from a long text cell (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Check whether a cell contains a substring (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Validate a cell against a regex pattern (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Validate that a cell contains a real email address (formula tutorial) Extracting structured pieces of text from a free-form cell — emails out of a notes column, phone numbers…
- Combine first and last name into a single cell — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Build a comma-separated list from a column — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Concatenate cells with line breaks in Google Sheets — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Build a multi-line address block from address fields — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Concatenate while keeping number formatting (TEXT) — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Join an array of values with TEXTJOIN — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Conditionally concatenate values that match a criterion — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Build a CSV line from a row in Google Sheets — formula walkthrough Combining text pieces into a single cell is constant work in spreadsheets — full names from first plus…
- Remove leading, trailing, and internal extra spaces — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Strip non-printable characters from imported text — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Remove line breaks from a column of text — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Replace non-breaking spaces (CHAR 160) with regular spaces — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Normalize mixed-case text to Proper case — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Strip special characters from a text column — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Standardize product codes (uppercase, no spaces) — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Clean imported CSV data before further processing — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…
- Find and replace values across a range with a formula — formula tutorial Real spreadsheet text is messy: trailing spaces from a paste, mixed case from form submissions, invisible whitespace from…