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

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

Sidebar