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