I'm not sure where B3 comes into it because you describe haveing Sales in B2
and names in C2, C3 and C4 but if I have understood put this in any cell and
drag down.

=$B$2&" "&C2

And see if that's what you require.

Mike

"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