How To Use Excel TEXTJOIN Function?

Ads

TEXTJOIN Function in Excel: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. This application is developed for Windows, Mac, Android, and iOS. The major purpose of the software is to do complicated calculations which are difficult to do manually.

Here, in this article, we will illustrate the definition, syntax, and usage of the TEXTJOIN function in Microsoft Excel. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Definition of TEXTJOIN Function

It is one of the built-in functions in Microsoft Excel.
The Excel TEXTJOIN Function concatenates or joins values with or without the delimiter.
This function will efficiently concatenate the ranges if the delimiter is an empty text string.

Syntax

Here, you will see the syntax of the TEXTJOIN function.
To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
Once you enter the formula, just click on the Enter button to get the result.

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Argument Explanation:

Delimiter (Required): The string or separator that is inserted between each text value. It can be empty/one or more characters enclosed by double-quotes.
Ignore_empty (Required): TRUE – Ignores empty cells. FALSE – Include empty cells.
Text 1 (Required): Text value that needs to be concatenated. It can be a text string or a range of cells or an array of strings.
Text 2 (Optional): Second text value or range.

Examples

Let’s look at some practical examples of the TEXTJOIN Function and explore how to use it in Microsoft Excel.

Example 1: Joining Two Text Strings

Initially, you have to open your Excel workbook on your PC and launch the worksheet that has data.
For example, we have given two text strings in Cell B3 and C3. We will join the strings using the TEXTJOIN function.

We have given the delimiter in the applied formula. Then, you have to enter the formula in the cell as shown below to get the result.

After entering the formula, you need to click the Enter button to get the output.

Example 2: To join cells in the range with no delimiter

In the following image, we have shown the range of input values and we will join them using the TEXTJOIN function without using a delimiter.

Then, you have to enter the formula in the cell as shown below to get the result.

After entering the formula, you need to click the Enter button to get the output.

Verdict

The above article illustrated how to use TEXTJOIN Function in Excel with clear-cut practical examples. If this article is helpful to you, leave feedback in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.