5 Replies Latest reply on Apr 3, 2010 10:44 AM by LaRetta_1

    Combining First Middle Last Name using IsEmpty

    dwhylanjr

      Title

      Combining First Middle Last Name using IsEmpty

      Post

      I am wanting to combine a person's First, Middle and Last Name into one field.  When I use the following calculation and there is no Middle Name it inserts a blank so that a name looks like this "John  Doe" instead of "John Doe".

       

      Name_Title & " " & Name_First & " " & Name_Middle & " " & Name_Last 

       

      I seem to recall a discussion in this forum a while back about using "IsEmpty" to remove unwanted spaces when a field is empty.  I just cannot find the discussion.

       

      Can someone point me in the right direction or give me a sample calculation that would prevent that unwanted space when a middle name is missing?

       

      David