You can use the **TEXTJOIN** function in Excel to combine multiple text values using a specific delimiter.

If you only want to combine cells based on criteria, you can use the **TEXTJOIN** function with the **IF** function as follows:

=TEXTJOIN(", ",TRUE,IF(B2:B11="Western",A2:A11,""))

This particular formula combines the text values in the range **A2:A11** only if the corresponding cell in the range **B2:B11** is equal to “Western.”

The following example shows how to use this formula in practice.

**Example: How to Use TEXTJOIN IF in Excel**

Suppose we have the following dataset in Excel that contains information about various professional basketball teams:

Suppose we would like to combine each of the team names into one cell, *only if* the team belongs to the Western conference.

We can type the following formula into cell **D2** to do so:

=TEXTJOIN(", ",TRUE,IF(B2:B11="Western",A2:A11,""))

The following screenshot shows how to use this formula in practice:

Cell **D2** has joined together each of the team names that belong to the Western conference, with a comma used as a delimiter.

If we view the original dataset, we can confirm that each of the teams included in cell **D2** do indeed belong to the Western conference:

**Note #1**: To use a different delimiter to join together the text values, simply specify that delimiter in the first argument of the **TEXTJOIN** function.

**Note #2**: You can find the complete documentation for the **TEXTJOIN **function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Convert Column into Comma Separated List

Excel: How to Use TEXTJOIN Function with Line Break

Excel: How to Use a Concatenate If Formula