Excel Tutorial – TEXTJOIN

The TEXTJOIN function in Microsoft Excel is a function that concatenates (joins together) a range of text strings into a single string, using a specified delimiter (separator) between each string. This function is useful for combining and manipulating text data in Excel.

To use the TEXTJOIN function, follow these steps:

1. Open Microsoft Excel and select the cell where you want the result to appear.
2. Type the following formula into the cell: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
3. Replace “delimiter” with the character or string that you want to use as the separator between the text strings.
4. Replace “ignore_empty” with the value TRUE or FALSE, depending on whether you want to ignore empty cells or include them in the result.
5. Replace “text1”, “text2”, etc. with the cell references or ranges of cells that contain the text strings that you want to concatenate.
6. Press Enter to see the result.

The TEXTJOIN function concatenates all of the text strings in the specified range, using the specified delimiter between each string. It returns a single string that contains all of the text strings, with the delimiter separating each string.

You can use the TEXTJOIN function to combine and manipulate text data in Excel. It is a very useful tool for working with characters and strings in Excel.