How to Use TEXTJOIN Function in EXCEL

Excel 2016 TEXTJOIN function with Delimiter option

In Excel 2016 we have a new TEXT function with a delimiter option.

How to use TEXTJOIN function in Excel
TEXTJOIN function Description

This function will help users not only joining the text but also allows to give a delimiter with the choice of including or excluding blank cells in a given range.

The syntax of the function:

How to use TEXTJOIN Function in EXCEL
TEXTJOIN Syntax

1st argument (Compulsory argument) is a delimiter which will allow you to separate each text.

2nd argument (Compulsory argument) is to ignore the blank cells.  If you select TRUE then it will ignore the blank cells. If you want blank cells to be included then we should select the FALSE option.

3rd argument (Compulsory argument) we can select the entire range which contains the required values.

See below example TEXTJOIN function is used:-

D7=TEXTJOIN(“/”,TRUE,B5:B11)

How to use TEXTJOIN function in Excel
Example of TEXTJOIN Function in Excel

1 Response

  1. Thanks alot i have learned now how to use TEXTJOIN function in Excel. After going through this website i have learnt so many Excel tips at free of cost.
    This is Best website I can say to learning Excel online free of cost.