This formula will conditionally concatenate a range based on a criteria in another range.
The Syntax of the Concatenate function is given below: Like, it does not provide spacing between the texts that you want to concatenate. The Concatenate function does not provide the delimiter. Give it a try and ensure to read up on the parts that you don’t get correctly.
