How to Use TEXTJOIN Function in EXCEL

Last modified date

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

3 Responses

  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.

    • Thanks for following my website and learning how to use Excel TEXTJOIN function. You can also learn How to Use Excel Vlookup, REPT FUNCTION IN EXCEL and Excel Pivot table and other Excel functions.

Leave a Reply

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

Post comment