By SC
Text join in excel is used to join two or more cells and have more useful than concatenate function in excel.It can join two text or cell in very easy way.
How to join cells using Text join in Excel:
Here we will learn how to join cells in excel using text join
=Textjoin(” “,,D5:E5)
we have used comma to ignore spaces if we don’t write comma it will give the same result as concatenate.
In below table we have three columns name, middle name and last name on which we have applied concatenate function and text join function in last and second last columns.
When we apply concatenate at these row i will include space in third row names but text join we can ignore spaces.
