Combining Cells for an Address

Not applicable

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"?

2 Replies



Please find below solution will be helpful for you






Regards, Faraz Shaikh 

With firest name in A2 and last name in B2 try:


=TRIM(A2&" "&B2)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies