Forum Discussion
Deleted
Jan 26, 2019Concat Formula
I am trying to create a formatted cell of combining a few cells and a possible if formula. The workbook I am creating is listing people who have donated money, some will be a husband and wife and som...
SergeiBaklan
Jan 26, 2019Diamond Contributor
That could be
=B2 & IF(LEN(C2)>0, " and " & C2,"") & " " & A2