Google Sheets - Replace Special Characters - Lower Case - Concatenate

Written by PromoMagic on 29 January 2016. Posted in Code and Formulas

Today I made something beautiful. But you probably have to appreciate excel formulas to appreciate this! This formula is used to create aliases or slugs.

We use slugs to create custom URL's for our products and categories, since we ditched our SEF URL component due to speed issues we now store them as a single line in the database.

Simply replace A1 and A2 with your Product Title and SKU respectively.

=CONCATENATE(LOWER(REGEXREPLACE(A1,"[^A-Za-z0-9]","-")),"-",A2)

Follow On: This formula substitutes double -- with single -.

=substitute(CONCATENATE(LOWER(REGEXREPLACE(A1,"[^A-Za-z0-9]","-")),"-",A2),"--","-",)