JOIN IF formula help!
I'm looking to Join 2 contact columns into 1 text column* with something to space the 2 values out so the names in the formula column do not run together w/out spaces.
The problem with this is that if there is a missing value in 1 or both reference columns, the character I'm using to space ("  ") appears for no reason.
IMAGE OF ISSUE BELOW: The first row is appearing correctly, but all rows beneath are displaying my problem.
FORMULA CURRENTLY IN USE: =[Neo Exec]@row + "  " + [Neo Coordinator]@row
I think I need to incorporate an "IF" statement so that the spacing character does not appear unless it is needed (i.e., unless there is a value in BOTH columns, not just 1 column, and definitely not if both columns are blank!), but I haven't been able to crack exactly how to phrase it (my formula work/knowledge is limited, as you can see).
THANK YOU in advance, for any help/tips/suggestions!!!
LK
(*I'm applying this formula to a text column as I do not believe it's possible to make a contact column a formula column, but if anyone knows of a workaround to make that a reality, I would be anxious to hear it!)
Best Answer

NEVERMIND! I figured out a workaround using "CHAR(10))"
:)
Answers

NEVERMIND! I figured out a workaround using "CHAR(10))"
:)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!