I would use the feature in ASAP Utilities to fill down the blanks in column B
with the values above and then do a straight concatenation, like
=B2&" "&C2, copied down

ASAP Utilities is a free add-in available at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3




"Sunnyskies" wrote:

Afternoon from Sunny SA,

Picture this.

In column B I have a job title in row 2 (Sales).
In column C I have applicant names in row 2, 3 & 4 (Peter, John & Paul)

Now I want to concatenate column B & C to get Sales Peter, Sales John and
Sales Paul.

How do I get Sales against Paul with a formula.

I was using the formual If(B4="",B3&C4, B4&C4), but this does not work if
there is a blank in cell B3.

Thanks