Excel Formula to Slugify Text

How to create a url slug version of some text using Excel.

note this doesnt do anything fancy just replaces spaces with hyphens and lowercases it and trims extra whitespace. If you wanted to do something more fancy then you’d be looking at writing some vba code..

Formula
=LOWER(SUBSTITUTE(TRIM(A2), ” “, “-“))

Example: