Forum Discussion

Deleted's avatar
Deleted
Dec 21, 2018

Combining Cells for an Address

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 wh...
Excel
Formulas and Functions
ExcelExciting's avatar
ExcelExciting
MVP
Dec 23, 2018

Hi,

 

Please find below solution will be helpful for you

 

  

 

=IF(ISBLANK(B2),A2,IF(ISBLANK(A2),B2,CONCATENATE(A2," ",B2)))

Regards, Faraz Shaikh 

  • Hans Knudsen's avatar
    Hans Knudsen
    Copper Contributor
    Dec 27, 2018

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

     

    =TRIM(A2&" "&B2)

Resources