Greetings,
I have a sheet of data that looks like this:
BuyerLast[tab][tab][tab]BuyerFirst[tab]CoBuyerFirst
SELF[tab][tab][tab][tab][tab]STEVEN[tab][tab]RAMONA
CAMPISE[tab][tab][tab]JOHN
WHITTENBURG[tab]JAMES[tab][tab]HEIDI
ROGERS[tab][tab][tab]KENNETH[tab][tab]PAMELA
SICKLER[tab][tab][tab]JERRY
I would like to concatenate these three cells but with a small condition; If there is no CoBuyerFirst then the concatenation should look like this: BuyerFirst & " " & BuyerLast
However, if CoBuyerFirst is not null, then the concatenation should look like this:
BuyerFirst & " and " & CoBuyerFirst & " " & BuyerLast
How could I loop through those particular columns in my worksheet and generate this column with the above concatenations? To make things simple for any example code, say "BuyerLast" is column B, "BuyerFirst" is column C, "CoBuyerFirst" is column D, and the concatenation result should be column A.
Thank you in advance,
~Melagan
______
"It's never too late to become what you might have been.
I have a sheet of data that looks like this:
BuyerLast[tab][tab][tab]BuyerFirst[tab]CoBuyerFirst
SELF[tab][tab][tab][tab][tab]STEVEN[tab][tab]RAMONA
CAMPISE[tab][tab][tab]JOHN
WHITTENBURG[tab]JAMES[tab][tab]HEIDI
ROGERS[tab][tab][tab]KENNETH[tab][tab]PAMELA
SICKLER[tab][tab][tab]JERRY
I would like to concatenate these three cells but with a small condition; If there is no CoBuyerFirst then the concatenation should look like this: BuyerFirst & " " & BuyerLast
However, if CoBuyerFirst is not null, then the concatenation should look like this:
BuyerFirst & " and " & CoBuyerFirst & " " & BuyerLast
How could I loop through those particular columns in my worksheet and generate this column with the above concatenations? To make things simple for any example code, say "BuyerLast" is column B, "BuyerFirst" is column C, "CoBuyerFirst" is column D, and the concatenation result should be column A.
Thank you in advance,
~Melagan
______
"It's never too late to become what you might have been.