Combining 2 Columns with Text


#1

I have a column (%) that has a number. Example 20%
I have a column that has a pre-header text (short text) Example: the perfect fit to your budget software
I have a column that has a lookup for Product Featured Example: Airtable

From these, I want to create the title for my email campaign.

Save {Amount Off} on {Pre-Header} with {Product Featured}

It would look like:

Save 20% on the perfect fit to your budget software with Airtable

How do I put this into a formula?


#2

Use the following formula:

"Save " & {Amount Off} & " on the " & {Pre-Header} & " with " & {Product Featured}


#3

Thank you. That worked!