Extra Lines from Formula using TRIM() and & "\n" &&

[Scott_Brasted]

I have addresses with several fields, some fields are not always necessary.

• Member
• Organization
• Mail Address
• 2nd Mail Address
• City
• State
• Zipo Code

Trying to get a multi line field that has no blank lines.

Here's the formula I am using. I cannot find a way to get rid of the blank lines. What am I doing wrong?

I also included a screen shot of the existing multiline field.

Thanks in advance for any help, Scott

TRIM(
IF(
  AND(
      Organization,
      {2nd Mail Address}
      ),
      Member & "\n" & Organization & "\n" & {Mail Address} & "\n" & {2nd Mail Address} & "\n" & City & ", " & State & " " & {Zip Code},
IF(
  AND(
      Organization,
      {2nd Mail Address} = BLANK()
      ),
      Member & "\n" & Organization & "\n" & {Mail Address} & "\n" & City & ", " & State & " " & {Zip Code},
IF(
  Organization = BLANK(),
  Member & "\n" & {Mail Address} & "\n" & {2nd Mail Address} & "\n" & City & ", " & State & " " & {Zip Code},
IF(
  AND(
      Organization = BLANK(),
      {2nd Mail Address} = BLANK()
      ),
      Member & "\n" & {Mail Address} & "\n" & City & ", " & State & " " & {Zip Code}
)))))

[pressGO_design · Accepted solution]

Instead of trying to address every permutation of data, you can create IF statements for each option with the “/n”+field when it’s true. Everyone has a name, a city, state, and zip code, so 

Trim(
Member&
IF(Organization, “/n”&Organization)&
IF(mailAddress, “/n”&mailAddress)&
IF(2ndMailAddress, “/n”&2ndMailAddress)&
”/n”&City&”, “&State&” “&Zip
)

[Scott_Brasted]

Wow, thank you pressGO_design. I sometimes get too literal and too verbose when writing formulas.  Really appreciate the help. I will store this away for the future too. Best, Scott