The Excel TEXTJOIN Function

The TEXTJOIN function is used to join text in different cells. Isn't it what CONCAT and CONCATENATE function do? Then why another function to just add text?

The TEXTJOIN function not only adds given text values but also has control over delimiters and ignoring the blank cells. This feature is not available in CONCAT and CONCATENATE function.

This function is available in Excel 2019 and Excel 365.

Syntax of the TEXTJOIN Function

=TEXTJOIN(delimiter, ignore_empty_cells,text1,[text2],...)

Delimiter : This is the delimiter that you want to use a separator of among individual texts. It can be comma (,), semicolon (;) or anything, even nothing.

Ignore_empty_cells : This is a binary variable. Set it to TRUE if you want to ignore empty cells in ranges, else set to FALSE to include the empty cells.

Text1 : This is the text that you want to join. It can be individual texts, cells or entire ranges.

Let’s understand TEXTJOIN function with an example

Example of The TEXTJOIN Function

Here I have some text values in range A2:E2. I want to join these text values with a space in between each text. The formula will be simply:

=TEXTJOIN(" ",1,A2:E2)

Here, I have simply used space as a separator. I want my function to ignore any blank cells, so I set ignore_blank_cells to TRUE. Finally, I passed the range that I wanted to join. And that is it. It returns the output as we expected.

If you don't want to ignore the blank cells, set the ignore_blank_cells to FALSE.


The above function does not ignore any blank cell and adds all the texts with a comma.

Here, you can see an extra comma in the output. If we had set the ignore_blank_cells to True, there would be no extra commas as the formula would have ignored the blank cell.

Note: This function is available in Excel 2019 and 365. 

So yeah guys, this was a short introduction to the TEXTJOIN function of Excel. I hope I was able to explain how to use the TEXTJOIN function in the simplest way. If you have any doubts regarding this function or any other query, ask in the comments section below.

Excel 2019/365 Functions:

How to Use The Excel UNIQUE Function | The UNIQUE function returns the Unique values from the given array.

The SORT Function in Excel | The SORT function returns the sorted form of the supplied array.

How to Use Excel SORTBY Function | The SORTBY function sorts a given range by a different specified range. Sorting range does not need to be part of the table.

How to Use The Excel FILTER Function | The FILTER function returns all matched values of given criteria and spills the result into adjacent cells.

The SEQUENCE Function in Excel | The SEQUENCE function returns a series of sequential numbers. It is a dynamic array formula.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

How to use the VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.

How to use the COUNTIF function in Excel 2016 | Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to use the SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.