10 Replies Latest reply on Nov 15, 2016 10:38 AM by beverly

    If statement to merge fields

    hferrell

      I am trying to merge 2 fields if the second field is not empty.  Excel function is: =IF(B1<>"",A1&" & "&B1,A1)

      Sample

      Header 1Header 2Header 3
      JohnJaneJohn & Jane
      JoeJoe

       

      My fields names to merge are: ClientFirstName (A1) and SpouceFirstName (B1)  (as expressed in Excel formula)

      Thanks for any suggestions.

      Hal