How to used Concatenate vs & vs Concat vs TextJoin Excel function to merge or joint text

How to used Concatenate vs & vs Concat vs TextJoin Excel function to merge or joint text

We can join text using Concatenate, &, Concat and TextJoin function in Excel. Although CONCAT and TEXTJOIN functions are available only in Office 2016, 2019 & Office 365 versions.
Let's have a look at the syntax and arguments of the functions:

CONCATENATE:

Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Syntax: CONCATENATE(text1, [text2], ...)

text1 (required)

The first item to join. The item can be a text value, number, or cell reference.

Text2, ... (optional)

Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters.

CONCAT:

This function replaces the CONCATENATE function. However, the CONCATENATE function will stay available for compatibility with earlier versions of Excel.

The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.

Syntax: CONCAT(text1, [text2],…)

text1
(required)

Text item to be joined. A string, or array of strings, such as a range of cells.

[text2, ...]
(optional)

Additional text items to be joined. There can be a maximum of 253 text arguments for the text items. Each can be a string, or array of strings, such as a range of cells.

TEXTJOIN:

The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

Syntax: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

delimiter
(required)

A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.

ignore_empty
(required)

If TRUE, ignores empty cells.

text1
(required)

Text item to be joined. A text string, or array of strings, such as a range of cells.

[text2, ...]
(optional)

Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.

#ConcatenateFunction #&function #ConcatFunction #TextJoinFunction
#Concatenate #& #Concat #TextJoin #expertInSkill #samalis390
#msexcel #excelFormula #msexcelTrick #excelTipsAndTricks