Dec 21 2018 07:54 AM
Dec 21 2018 07:54 AM
Hey there,
I am taking a database file of customers where there are two people listed as the purchasers and sending out a New Year's card. I'd like to combine the cells of the two customers to where it on the address it will say "First & First Last" but I also know that not all of our customers share the same surname. How can I set up a formula to where it will combine the information to say "First & First Last" if they share that surname but also recognize when the surname isn't the same and create "First Last & First Last"?
Dec 22 2018 09:40 PM - edited Dec 22 2018 09:40 PM
Hi,
Please find below solution will be helpful for you
=IF(ISBLANK(B2),A2,IF(ISBLANK(A2),B2,CONCATENATE(A2," ",B2)))
Regards, Faraz Shaikh
Dec 27 2018 08:21 AM
With firest name in A2 and last name in B2 try:
=TRIM(A2&" "&B2)