How to use Excel CONCAT Function

Introduction

CONCAT in excel is a text/string function. This function is used to merge several text strings or ranges. This function was included in Excel 2016 and available in later versions, it replaced CONCATENATE function. This function does not include delimiter/Ignore Empty arguments.

Syntax

=CONCAT(Text1, Text2, ….)

Arguments

Text1: It is the text values which will be merged together, can be a string or an array of strings or a range of cells.
Text2: Additional text values to be joined, maximum 253 text arguments.

Keynotes

This function is available in latest Excel versions.
This function does not include delimiter/Ignore Empty arguments.
If delimiter are necessary than use TEXTJOIN function.
If the characters in the string are more than 32767 in numbers, #VALUE error is displayed.
This function was included in Excel 2016 and available in later versions, it replaced CONCATENATE function.

Examples

In this example, CONCAT function is used to merge characters from column A to D into column E as follows:

Value1	Value2	Value3	Value4	Result
B	O	S	S	BOSS
8	0	5	5	8055

CONCAT function example file Download