Skip to main content

Change space with -

  • August 26, 2022
  • 1 reply
  • 9 views

Forum|alt.badge.img+2

Hello
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

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • August 26, 2022

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.