Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a content ops analyst publishing 12 articles to a CMS that auto-builds URLs from a slug column. Article titles in column A are mixed case with spaces ("How to Cook Pasta"); the CMS needs them as lowercase kebab-case ("how-to-cook-pasta") — lowercase letters with hyphens between words.
Your task:
The two-step pattern is SUBSTITUTE (replace spaces with hyphens) wrapped in LOWER (fold to lowercase): =LOWER(SUBSTITUTE(A2, " ", "-")). The composition order matters — both directions produce the same output here, but the convention is to do the replacement first (which preserves the structure) then the normalization (which only changes character case).
The data is clean: single space between words, no punctuation, no double-spaces, no leading/trailing whitespace. (Real CMS slugifiers also strip punctuation and collapse runs — that's a harder problem covered later in this batch.)
Graded cells: B2 (How to Cook Pasta → how-to-cook-pasta), B5 (Why Spreadsheets Matter → why-spreadsheets-matter), B12 (Lead Magnets That Convert → lead-magnets-that-convert).