Excel TextJoin Function

This post will guide you how to use Excel TEXTJOIN function with syntax and examples in Microsoft excel. how to concatenate strings using the TEXTJOIN function in excel 2016. we can use CONCATENATE function to join text in differenct cells in 2013 or lower version excel.

Description

The Excel TEXTJOIN function joins two or more text strings together and separated by a delimiter. you can select an entire range of cell references to be combined in excel 2016. and you can also specify a en empty string as delimiter to include between each texts in different cells.

The TEXTJOIN function is a build-in function in Microsoft Excel and it is categorized as a Text Function.

The TEXTJOIN function is only available in Excel 2016.

Syntax

The syntax of the TEXTJOIN function is as below:

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

Where the TEXTJOIN function arguments are:
delimiter -This is a required argument. It can be a text string or empty string to join text values with a given delimiter, it can be a space,comma,hash or other text string.
Ignore_empty – This is a required argument.  If TRUE, empty cells or string value should be ignored.
Text1/Text2– This is a required argument.  One or more strings that you want to join together.
Note: the text arguments should not exceed 252 and the length of resulting string should not exceed the cell limit of 32767.

Excel TEXTJOIN Function Examples

The below examples will show you how to use Excel TEXTJOIN Text function to concatenate the items of one or more text strings using a specified delimiter.

#1 To join strings in B1,C1,D1 cells, just using formula:= TEXTJOIN (“,”,TRUE,B1,C1,D2).

excel textjoin function example

#2 while you want to concatenate the strings by specifying multiple delimiter and order, you can use the following formula:

=TEXTJOIN({“@”,”.”,”.”},TRUE,A1:C1)

excel textjoin function example2

#3 To join values from the multiple cell ranges with a double dash character as delimiter. using the following formula:

=TEXTJOIN(“–“,TRUE,A1:A4,B1:B4)

excel textjoin function example3

#4 to join string in range cell A1:C1 by a comma character as delimiter and empty cells should not be ignored. using the following formula:

=TEXTJOIN(“,”,FALSE,A1:C1)

More TEXTJOIN Formula Examples

  • Remove Numeric Characters from a Cell
    If you want to remove numeric characters from alphanumeric string, you can use the following complex array formula using a combination of the TEXTJOIN function, the MID function, the Row function, and the INDIRECT function..…
  • remove non numeric characters from a cell
    If you want to remove non numeric characters from a text cell in excel, you can use the array formula:{=TEXTJOIN(“”,TRUE,IFERROR(MID(B1,ROW(INDIRECT(“1:”&LEN(B1))),1)+0,””))}…
  • How to combine Text from Two or More Cells into One Cell
    If you want to combine text from multiple cells into one cell and you can use the Ampersand (&) symbol.If you are using the excel 2016, then you can use a new function TEXTJOIN function to combine text from multiple cells…

Related Functions

  • Excel TEXTJOIN function
    The Excel TEXTJOIN function joins two or more text strings together and separated by a delimiter. you can select an entire range of cell references to be combined in excel 2016.The syntax of the TEXTJOIN function is as below:= TEXTJOIN  (delimiter, ignore_empty,text1,[text2])…
  • Excel MID function
    The Excel MID function returns a substring from a text string at the position that you specify.The syntax of the MID function is as below:= MID (text, start_num, num_chars)…
  • Excel LEN function
    The Excel LEN function returns the length of a text string (the number of characters in a text string).The LEN function is a build-in function in Microsoft Excel and it is categorized as a Text Function.The syntax of the LEN function is as below:= LEN(text)…
  • Excel IFERROR function
    The Excel IFERROR function returns an alternate value you specify if a formula results in an error, or returns the result of the formula.The syntax of the IFERROR function is as below:= IFERROR (value, value_if_error)….
  • Excel ROW function
    The Excel ROW function returns the row number of a cell reference.The ROW function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function.The syntax of the ROW function is as below:= ROW ([reference])….
  • Excel INDIRECT  function
    The Excel ROW function returns the row number of a cell reference.The ROW function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function.The syntax of the ROW function is as below:= ROW ([reference])….

Related Posts

How to Find and Highlight Duplicate Rows in Excel
find duplicate rows6

This post will guide you how to find and highlight duplicate rows in a range of cells in Excel. How do I find duplicate rows in a range with a formula in Excel. How to find duplicate rows in two ...

Reverse Text String in Excel
reverse text string 2

This post will guide you how to reverse text string in Excel. How do I reverse text string in one cell with an Excel User Defined Function. How to reverse a text string in one cell with a formula in ...

Convert Column to Comma Separated List in Excel
convert column5

This post will guide you how to convert column list into a comma separated list in one cell in Excel. How do I convert a column into a comma separated list with a formula in Excel. Or how to convert ...

Removing Non Numeric Characters
remove non numeric characters2

This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. ...

How to Combine Text from Two or More Cells into One Cell
Combine text using TEXTJOIN function1

This post explains that how to combine text from two or more cells into one cell in excel. How to concatenate the text from different cells into one cell with excel formula in excel. How to join text from two ...

How to remove non numeric characters from a cell
remove non numeric characters from a cell2

This post explains that how to remove non-numeric characters (numbers) from a text string in one cell in excel 2016. How to remove non numeric characters from a cell containing text string with an excel formula. And how to remove ...

How to Remove Numeric Characters from a Cell
remove numeric characters from a cell3

This post explains that how to remove numeric characters (numbers) from a text string in one cell in excel 2016. how to remove only numeric characters but keep the non-numeric characters from a cell containing text string with an excel ...

The difference between Replace function and Substitute function in Excel
The difference between Replace function and Substitute function1

There are two similar functions to replace text string in Excel. They are REPLACE and SUBSTITUTE functions. What’s the difference between REPLACE function and SUBSTITUTE function in excel 2013?  This post will introduce the difference between those two function in ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar