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.
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 … Continue Reading