Home

Concat Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-326087%22%20slang%3D%22en-US%22%3EConcat%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326087%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formatted%20cell%20of%20combining%20a%20few%20cells%20and%20a%20possible%20if%20formula.%20The%20workbook%20I%20am%20creating%20is%20listing%20people%20who%20have%20donated%20money%2C%20some%20will%20be%20a%20husband%20and%20wife%20and%20some%20single.%20So%20Cell%20B2%20has%20the%20husbands%20name%20(first%20or%20only%20name)%2C%20Cell%20C2%20would%20have%20the%20Wife's%20name%20(second%20name)%20and%20A2%20would%20have%20the%20family%20name.%20I%20want%20to%20combine%20in%20another%20cell%20the%20First%20persons%20name%20and%20IF%20there%20is%20a%20wife's%20name%20and%20then%20the%20family%20name.%20Is%20there%20a%20way%20to%20do%20this%3F%20For%20example%2C%20I%20would%20want%20the%20cell%20to%20either%20populate%20%22Mike%20and%20Jane%20Doe%22%20or%20%22Mike%20Doe%22%20if%20there%20is%20no%20second%20name.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326087%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326100%22%20slang%3D%22en-US%22%3ERe%3A%20Concat%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326100%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DB2%20%26amp%3B%20IF(LEN(C2)%26gt%3B0%2C%20%22%20and%20%22%20%26amp%3B%20C2%2C%22%22)%20%26amp%3B%20%22%20%22%20%26amp%3B%20A2%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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. 

1 Reply

That could be

=B2 & IF(LEN(C2)>0, " and " & C2,"") & " " & A2
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies