TEXTJOIN Formula in Excel
The TEXTJOIN formula joint (concatenates) values with a specific delimiter. It allows you to supply a range of cells, and also has a setting which can help you to ignore empty values.
Formula breakdown is written here:
=TEXTJOIN(delimiter, ignore_empty, text1, …)
Delimiter= it is the separator between each text.
Ignore_empty = ignore empty cells in combining text.
Text1 = first text/range to combine.
If you want to combine text or a range of cells together easily then TEXTJOIN formula will help you. TEXTJOIN formula was introduced in excel 2019.
It will help you in specifying a delimiter to use to combine the text together and ignore the empty cells for you.
Previously In Excel Formulas: How to use SWITCH Formula in Excel? (2 SIMPLE STEPS)
Following are the steps for applying TEXTJOIN in excel:
STEP1. You have to enter the TEXTJOIN function in a blank cell:
STEP2. Now continue with the TEXTJOIN arguments:
Now you have to decide which delimiter you want to use to combine the text.
You have to combine the text together and separate them by a comma:
You set the TRUE to ignore empty cells while combining them together:
Select the range of cells that you have to combine together
=TEXTJOIN(“,”, TRUE, A2:D2)
Now with the help of lower right corner apply this formula to the other cells by dragging it downwards.
Here is your result;