S
Sunnyskies
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
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