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.

Concate but exclude grammar along with excluded cell

Topic Labels: Formulas
Solved
Jump to Solution
289 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi.

Noob alert!

This is my first attempt at formulas of this nature. I am trying to concate an address (Street 1, Street 2, City, State, Postcode, Country), separated by a comma and space (", ").

However, most addresses I enter do not fill the ‘Street 2’ cell, which results in an additional ", " in the formula outcome. I have spent hours trying to correct this and cannot figure it out.

I would be grateful for any assistance! Thank you.

Here is an image of the issue:

Shared with CloudApp

Here is the fomula I am using:

CONCATENATE({Street 1},", “,IF({Street 2},’’&{Street 2}),”, “,{City},”, “,{State},”, “,{Postcode},”, ",{Country})

1 Solution

Accepted Solutions

I figured it out :slightly_smiling_face:

IF({Street 2},CONCATENATE({Street 1},", “,{Street 2},”, “,City,”, “,State,”, “,Postcode,”, “,Country,”, “),CONCATENATE({Street 1},”, “,City,”, “,State,”, “,Postcode,”, ",Country))

See Solution in Thread

2 Replies 2

Trying to add a better picture of issue:

Image 2020-09-04 at 2.35.18 PM

I figured it out :slightly_smiling_face:

IF({Street 2},CONCATENATE({Street 1},", “,{Street 2},”, “,City,”, “,State,”, “,Postcode,”, “,Country,”, “),CONCATENATE({Street 1},”, “,City,”, “,State,”, “,Postcode,”, ",Country))