Google Sheets - Replace Special Characters - Lower Case - Concatenate

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),"--","-",)



Copyright © 2020 PromoMagic Ltd | +44 (0)1795859639 | This email address is being protected from spambots. You need JavaScript enabled to view it.

Registered in England and Wales Company Number: 11970723 -