First select the cell where you want the combined data to be displayed. Type CONCATENATE in that cell or in the formula bar. To combine text with numbers inside a formula you can use the ampersand operator.
If you type a comma as the delimiter the function will simply put a comma between all the content you want to join.
Just use the operator to concatenate the text and the formula. In Excel IF formulas you are not limited to using only one logical function. Excel can do it. Instead of using CONCATENATE simply use the operator.