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

### 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

Related Posts

Concatenate columns with Line Breaks (Alt + Enter)
This post will guide you how to combine multiple cells in one or more columns into one cell with line breaks or Alt +enter in Excel. How do I concatenate different values together into one cell with line breaks. For ...

How to Add Prefix or suffix to Cell
This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Highlight Duplicate Rows
This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a ...

How to Combine 3 Cells to Generate One Date
This post explains that how to create a date from 3 different cells in excel. How do I combine 3 general cells to one date cell using excel formula. Assuming that you have a list of data that contain three ...

How to insert leading zeros to number or text
This post explains that how to insert or add leading zeros in front of a number or text string in excel. How do add the leading zero to the front of the number using Text function in excel. Add leading ...

How to add text to the end all cells
In the previous post, we talked that how to add the same text into the beginning of the text in one cell or all selected cells. And this post will guide you that how to add the specified text or ...

How to add text to the beginning of all cells
This post explains that how to add the specified text or characters to the beginning of all cells in excel. How to create an excel formula to add same text string or characters to the beginning of text string in ...

How to combine columns without losing data
This post will guide you how to merge and combine multiple columns without losing any data in excel. How do I merge columns without losing data using Excel Formula. For example, you want to join two columns that contain first ...