Excel Concat Function

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)

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

Related Posts

Concatenate columns with Line Breaks (Alt + Enter)
concatenate columns with line break11

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
add prefix to cell113

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
highlight duplicate rows16

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
create date from 3 cells2

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
add text to end of text4

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
add text to beginning of cell4

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
combine columns3

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

How to Combine Text from Two or More Cells into One Cell
Combine text using TEXTJOIN function1

This post explains that how to combine text from two or more cells into one cell in excel. How to concatenate the text from different cells into one cell with excel formula in excel. How to join text from two ...

Combining the Replace function with Text function in Excel
Replace function combine with Text function in Excel1

In excel, we can use Replace function in combination with Text function to replace date characters that are part of the text string. And this post will guide you how to use TEXT function as the first arguments to replace ...

Sidebar