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