Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How I create formula that pulls data from two cells and eliminates the space by creating a dash between them

Topic Labels: Formulas
247 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone, thanks in advance for any support. I would like to create a formula that pulls organization names and what state they are in and eliminate the space and have a dash between them. I.E. Akoutis CA would be Akoutis-CA. See attachment
Question to the community

3 Replies 3

{Organization Name} & “-” & {State}

It looks like you sometimes don’t have a state, in which case I assume that you also do not want to have the dash.

CONCATENATE(
    {Organization Name},
    IF({State}, "-" & {State})
)

Thank you. This solution worked great. I appreciate it.