Excel Concat Function

This post will guide you how to use Excel CONCAT function with syntax and examples in Microsoft excel.

Table of Contents

Description

The excel CONCAT function combines 2 or more strings or ranges together.

This is a new function in Excel 2016 and it replaces the CONCATENATE function. However, the CONCATENATE function is still available for earlier version of Microsoft Excel.
​Note: The CONCAT function do not support the delimiter or Ignore Empty arguments.

The CONCAT function is a build-in function in Microsoft Excel and it is categorized as a Statistical Function.

The CONCAT function is available in Excel 2016. If you are using Excel 2013 or older version, just use the CONCATENTATE function instead.

Syntax

The syntax of the CONCAT function is as below:

=CONCAT (text1,[text2],…)

Where the CONCAT  function arguments are:
text1 – the strings that you want to combine together.
text2 – the additional strings to be joined

Example

#1 To join the strings from B1 to B5, just using the following excel formula: =CONCAT(B1,B2,B3,B4,B5)

excel concat function example1

#2 To join three strings: the string in Cell B1, a string with a space character and the string value in cell B2

excel concat function example2

Leave a Reply