That depends on how you want this to work. Here's one option, but it's not the only possibility:Case (IsEmpty ( First ) ; Last ;IsEmpty ( Last ) ; First ;Substitute ( List ( Title ; Last & ", " & First ; Middle ; Suffix) ; ¶ ; " " ))Case (IsEmpty ( First & Last ) ; Company ;IsEmpty ( First ) ; Last ;IsEmpty ( Last ) ; First ;Substitute ( List ( Title ; First ; Middle ; Last ; Suffix ) ; ¶ ; " " ))
The list function automatically omits list elements that are empty, but separates each element with a return character. The substitute function then replaces the returns with spaces.
Thank you, you are helping me make progress. I modified your order but it works fine.
Except for one small additional question re the CONTACT NAME LABELS layout (the second item you updated for me).
The Contact Name Labels look fine when I have a middle name (or initial) but when I don't there is one space too many before the First and the Last names.
And I'm durned if I can figure out how to fix it.
Here is what I have changed the Calculation field to (which as I say almost works, except for this two spaces between a first and last name when there is no middle name info.)Case (IsEmpty ( First & Last ) ; Company ;IsEmpty ( First ) ; Last ;IsEmpty ( Last ) ; First ;Title & " " & First & " " & MIDDLE & " " & Last & SUFFIX)
[Note: My SUFFIX info appears correct because I have "cheated" by typing a ", " i.e. a comma plus a space, at the head of each suffix in my popup list. That was my baby solution.]
Again, thank you so much for your help.
That extra space is why I used the substitute and list functions instead of the calculation that you are using.