Solution to concatenate specific fields only


I would greatly appreciate your help finding a solution to concatenate each of the following fields while ignoring fields which contain (just) the letter “X”. (I am using “X” to denote empty instead of leaving the filed empty).

FYI. This formula works for concatenating all fields while ignoring the blank ones.

IF({Login Companies}, " " & {Login Companies}) &
IF({Login Titles}, " " & {Login Titles}) &
IF({Login Persons}, " " & {Login Persons}) &
IF({Login Places}, " " & {Login Places}) &
IF({Login Differentiators}, " " & {Login Differentiators})

Many thanks!!!

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