How to combine text in excel by using the TEXTJOIN function

How to combine text in excel by using the TEXTJOIN function

Combining text in excel from different cells can be done in different ways. We can use ‘&’ to combine or can use CONCATENATE or CONCAT function to combine texts from different cells. But in all these methods when we are using some delimiters we need to put delimiter multiple times with every text also there was no provision of treating blank cells.

How to combine text in excel
How to combine text in excel

In the above example, we can two different examples of concatenation. One without any empty cell and the second with an empty cell. In the empty cell, we can see delimiters got concatenated when a cell has no value. Also, we see delimiter needs to use multiple times to concatenate it. To overcome this we can use the TEXTJOIN function of excel.

The syntax for TEXTJOIN is as given below

Syntax for textjoin function
The syntax for TEXTJOIN function
Components of TEXTJOIN Syntax:
delimiter: This is the sepatator between the two text
ignore_empty: it is to define whether empty cell needs to ignore or not
text1: first text to combine
text2: second text to combine
Textjoin
TEXTJOIN

In the above example, we can see how the TEXTJOIN function helps in concatenating the texts. Demiliter was used just one time and when text got empty cell it ignores demiliter and used just one demiliter.

That was all for the TEXTJOIN function.

You can also read about text join from the below links.

https://exceljet.net/excel-functions/excel-textjoin-function

https://www.contextures.com/xlcombine01.html

Leave a Comment

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