🧹 Topic hub · 5 tutorials
Duplicates, stray spaces, numbers stored as text, splitting names, extracting emails and drop-down lists.
Highlight values that appear in both columns in Google Sheets with a COUNTIF custom formula. Covers one column, both columns, same row, missing values, case and spaces.
Pull email addresses out of messy text in Google Sheets with REGEXEXTRACT. Covers whole columns, several emails in one cell, names, domains and validation.
Build a dependent drop-down in Google Sheets that works on every row and keeps working when you insert rows or add items. One helper formula, no named ranges.
TRIM leaves spaces behind? Find out exactly which character it is with one formula, then remove non-breaking spaces (CHAR 160), line breaks, tabs and zero-width characters in Excel or Google Sheets.
Numbers stored as text break SUM, lookups and sorting. Spot them in seconds, then convert with Convert to Number, Paste Special, Text to Columns, VALUE/NUMBERVALUE or Power Query, plus the hard cases.