Possible IF Formula required...

[Tingle]

Hi All,

I have been tasked to prep a large amount of data for mail merge.

However I am faced with this challenge.

Can anyone help me, I am thinking an IF statement may work...

Here is a snap shot of the basic data (Not real data)

A B C D E F G H
1 Title Initial LastName JointTitle JointInitial JointLastName RelationshipType Mail Merge Names
2 Mrs A Field ?
3 Mr J Delph Mrs B Delph Spouse ?


Ideally I need the outcome to reflect Mr J & Mrs B Delph, is this possible?

If not then a formula to show Mr J Delph & Mrs B Delph.

And then if the client has no partner, the outcome will just show Mrs A Field.

Thanks

Tingle

 

[Declamatory]

Try:

=IF(D2="",A2&" "&B2&" "&C2,A2&" "&B2&" "&C2&" "&" & "&D2&" "&E2&" "&F2)

 

[Declamatory]

Sorry I included the first person's surname if it was joint.
Try:

=IF(D3="",A3&" "&B3&" "&C3,A3&" "&B3&" & "&D3&" "&E3&" "&F3)

 

[Peter_SSs]

If you have Excel 2016 through Office 365, then here is another option.

Book1
	A	B	C	D	E	F	G	H
1	Title	Initial	LastName	JointTitle	JointInitial	JointLastName	RelationshipType	MailMergeNames
2	Mrs	A	Field					Mrs A Field
3	Mr	J	Delph	Mrs	B	Delph	Spouse	Mr J & Mrs B Delph
Concat names

Cell Formulas
Range	Formula
H2	=TEXTJOIN(" ",1,A2:B2,IF(D2="","","&"),D2:E2,C2)

 

[Tingle]

Thank you guys!

That's exactly what I am looking for!

Regards

Tingle

 

[Peter_SSs]

Good news! Thanks for letting us know.