OK Part 2 of my combining data from several cells to 1

[Bketchum]

Ok, now my question is:

I have several names to combine into one cell:

(example: cell B2 is Mary Smith, cell C2 is John Smith) I need cell D2 to read: Mary Smith and John Smith.

When I use the following formula:

=B2&" and "&C2

It works when I have 2 names. But if I only have 1 customer, Mary Smith it shows up as "Mary Smith and" in cell D2. How do I make the "and" show up only when I have 2 or more names? I am stumped.

Brooke

 

[onlyadrafter]

Hello,

try

=IF(ISBLANK(C2),B2,C2&" and "&B2)

P.S. Dont start a new thread, just continue the old one.