Jan 26 2019 07:23 AM
Jan 26 2019 07:23 AM
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 some single. So Cell B2 has the husbands name (first or only name), Cell C2 would have the Wife's name (second name) and A2 would have the family name. I want to combine in another cell the First persons name and IF there is a wife's name and then the family name. Is there a way to do this? For example, I would want the cell to either populate "Mike and Jane Doe" or "Mike Doe" if there is no second name.
Jan 26 2019 08:39 AM
That could be
=B2 & IF(LEN(C2)>0, " and " & C2,"") & " " & A2