Excel Function : CONCAT

Download now!

Excel Function : CONCAT




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

Microsoft Excel Reference Page


Syntax and Description of the CONCAT Excel Function

The syntax for the CONCAT function in Microsoft Excel is: =CONCAT(text1, text2, text3, …) where text1, text2, text3, … are the text strings that you want to concatenate.

About CONCAT Excel Function

The CONCAT function in Excel allows you to join together two or more text strings into one. For example, if you have a first name in one cell and a last name in another, you can use CONCAT to put them together in a third cell.