my formula idea: I want [Full Name] to display First, Middle, Last... but only
show [Middle Name] if there is text in the field. Currently it shows up as an
extra blank space, which doesn't look as neat. I know the first part of the
formula isn't set up correctly because no middle names are showing (because no
one has the middle name "*"), but this is just to get across the idea
that if any text is detected,
show middle name.
If([Middle Name]="*", ([First Name]&" "&[Middle Name]&" "&[Last Name]), ([First Name]&" "&[Last Name]))