hferrell

If statement to merge fields

Discussion created by hferrell on Nov 15, 2016
Latest reply on Nov 15, 2016 by beverly

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

Outcomes