Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Concatenate Two Fields and Substitute

Topic Labels: Formulas
Solved
Jump to Solution
1487 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Everyone,
I am new to Airtable and enjoy it (for the most part:). I am trying to concatenate two fields (done) and then replace or substitute the spaces " " with dashes “-”. I having trouble placing the substitute syntax and getting a circular reference error. Thanks in advance for your help!

1 Solution

Accepted Solutions
Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

ScottWorld, coming through in clutch, thank you and be well!

See Solution in Thread

2 Replies 2

Your formula would look something like this:

SUBSTITUTE(({Field 1} & "-" & {Field 2})," ","-")

Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

ScottWorld, coming through in clutch, thank you and be well!