This is a big advantage of using TEXTJOIN function instead of CONCATENATE or CONCA function.

How to use the 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. Following are the steps for applying TEXTJOIN in excel. You have to combine the text together and separate them by a comma.

This function can include or ignore empty cells in the output. TEXTJOIN Function 2 TEXTJOIN FALSEA3C3. TEXTJOIN Function 1 TEXTJOINFALSEA2C2 Its easy to concatenate strings in a range using the TEXTJOIN function.

Now lets assume that we wish to add the text Country before US. To use the TEXTJOIN Excel Worksheet Function select a cell and type. As the name says TEXTJOIN function is used to join texts together.

This function in Excel provides a far easier method of joining multiple strings when c. The syntax of the function. Notice how the formula inputs appear.

Syntax TEXTJOIN delimiter ignore_empty text1 text2. Now continue with the TEXTJOIN arguments. The Excel TEXTJOIN function concatenates multiple values together with or without a delimiter.

Now some of you might think that CONCAT Function also does the same thing then what is the difference. Now you have to decide which delimiter you want to use to combine the text. The TEXTJOIN function is a built-in function in Excel that is categorized as a StringText Function.