Combine two cells in a new cell, replace all spaces with dash, and lowercase

Question

Trying to combine two cells in a Google spreadsheet, replace all the spaces with a "-", and lowercase everything.

Cell 1: GWG-1

Cell 2: Product Name 1

New Cell 3: gwg-1-product-name-1

Answer 1

Your basic formula is:

=LOWER(SUBSTITUTE(A1," ","-"))

We can concatenate two cells together to get the desired output:

=LOWER(SUBSTITUTE(A1&"-"&B1," ","-"))

---

Google Sheets