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

Leave a Reply

Close Menu