Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/Concatenate-with-IF.xlsx

In this video, I demonstrate how to combine concatenation with an IF condition.

In the first scenario, I only want to concatenate a cell if it contains a text value. If the cell is empty I don't want it to be included in the concatenated text string.

In the second scenario, I want to concatenate values in a column if a condition is met in another column. I use the TEXTJOIN function to achieve this.
------------------------