Concate but exclude grammar along with excluded cell


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})

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))

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.