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)**

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

## Leave a Reply

You must be logged in to post a comment.