Statistical - CONCAT Function

Description

Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. To include delimiters (such as spacing or ampersands (&) between the texts you want to combine and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN Function.

In Excel 2016, CONCAT Function replaced the CONCATENATE Function.

Syntax

CONCAT (text1, [text2] ...)

Arguments

Argument Description Required/ Optional
text1 Text item to be joined. A string, or array of strings, such as a range of cells. Required
Text2, ...

Additional text items to join.

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.

 Optional

Notes

  • Use commas to separate adjoining text items.

  • Without designated spaces between separate text entries, the text entries will run together. You can add extra spaces as part of the CONCATENATE formula in two ways −

    • Add double quotation marks with a space between them " "

    • Add a space after the Text argument

  • If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! Error.

Applicability

Excel 2016

Example

CONCAT Function
advanced_excel_statistical_functions.htm
Advertisements