Thread: concatenate and add text only if second cell is not blank

I want to concatenate 2 cells, only if the second cell is not blank and add text in between the cells. for example cell A1 is a name and cell b1 is a name, I want to add both names together so that they come out like “Name 1 and Name 2”. If there is a blank 2nd cell, I just want the first name to show up without the “and”. I tried but can't seem to get rid of the "and" if the second cell is blank. =(A1&"AND"&A2) I have tried =Trim(a1&"and"&A2), I have also tried using If(a2<>" ") in that string... I still get the "and". I've spent hours searching for an answer...

Thank you so much, I must have had every variation of this string...I had forgot to mention that I would still need the first cell to show up - even if the second cell is blank...this is what my formula looks like after using what was posted....

='Client Data Input'!B11&IF('Client Data Input'!F11="",""," and "&'Client Data Input'!F11)

how do i add, show b11 no matter what?

makes sense?

again, thanks so much...progress gives me hope

You are right...there was an error in my formula...thank you again for the help....