Page 1 of 1

Slug generator for Google Sheets (Excel) Google Docs

Posted: Thu Feb 01, 2018 10:42 am
by Saman
Replace C2 with the text field of yours and place this under Slug field
=LOWER(SUBSTITUTE(REGEXREPLACE(REGEXREPLACE(TRIM(C2),"[^a-zA-Z0-9\s]",""),"\s{2,}"," ")," ","-"))

For MS Excel, you need to either implement REGEXREPLACE or use a more generic form =LOWER(SUBSTITUTE(TRIM(A2), ” “, “-“))