Megan_Cartwrigh - profile

Megan_Cartwrigh · Sep 03, 2020

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 ‘Stree...

Megan_Cartwrigh · Sep 03, 2020

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

Megan_Cartwrigh · Sep 03, 2020

Trying to add a better picture of issue:

User Statistics

User Activity

Concate but exclude grammar along with excluded cell

Re: Concate but exclude grammar along with excluded cell

Re: Concate but exclude grammar along with excluded cell