Excel CONCAT Function

Summary

The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT allows you to supply a range of cells to join, in addition to inpidual cell references.

Purpose

Join text values without delimiter

Return value

Result of concatenated text

Syntax

=CONCAT (text1, [text2], ...)

Arguments

text1 - First text value, cell reference, or range.
text2 - [optional] Second text value, cell reference, or range.

Usage notes

CONCAT is a new function in Excel 2016.
CONCAT can accept ranges in addition to inpidual cells