CONCAT Function. Concatenate strings.(Microsoft Excel)


Japanese version.

The CONCAT function was added in Excel 2016 to combine a specified range of text.
It is a new version of the existing CONCATENATE function.
Use the CONCAT function for its improved functionality.

How it works

=CONCAT(Text1 to 254)

Text1 to 254Required argument.
Specify the string or cell range to be concatenated.


It is superior to CONCATENATE and & because it can be used to specify a whole range of cells at once.
The function name is also shortened, so use the CONCAT function if there are more than three concatenations.

If numbers are specified, they are concatenated as characters.

The date will be a serial value.

Therefore, dates must be converted to strings with the TEXT function before using the CONCAT function.



Microsoft Excel Functions Text

Examples of Use

Formula to randomly extract a specified number of cells from a range of cells.

Formulas to extract text from a cell every specified number of letters.

Formulas to sort text in cells.

How to reverse text.

How to extract only numbers from text.