Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Change space with -

738 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way to replace all spaces with “-” in a cell?

I synced a cell with my website and what ever I put in to the cell in airtable becomes the webpage slug. So I can’t put a space in a slug. Any solutions for this?

1 Reply 1

SUBSTITUTE({field name}, " ", "-")

It is documented in the formula field reference.

Depending on your source, you might want to do other substitutions. For example, if your source might have punctuation, accents, or other special characters, you might want to change those characters as well. You can search these forums for other formulas for creating slugs.