Concatenate IF | TEXTJOIN IF | Concatenate IF Cell Contains Text

Microsoft Excel Tips and Tricks

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.

Credit Chester Tugwell