Help

Concate but exclude grammar along with excluded cell

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

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
Megan_Cartwrigh
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Megan_Cartwrigh
5 - Automation Enthusiast
5 - Automation Enthusiast

Trying to add a better picture of issue:

Image 2020-09-04 at 2.35.18 PM

Megan_Cartwrigh
5 - Automation Enthusiast
5 - Automation Enthusiast

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