How to Use CONCAT Function in Excel | Excel Formula Guide

Download PDF

Concat function - Combine text from two or more cells into one cell

• The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments.

Syntax:

CONCAT(text1, [text2],…)

For example, =CONCAT("The"," ","sun"," ","will"," ","come"," ","up"," ","tomorrow.") will return The sun will come up tomorrow.

Video Tutorial: Join First Name and Last Name in the Excel - CONCAT function

See also:

• Excel Help & Training - Combine text from two or more cells into one cell

Exercise:

1. In cell D1, type the following formula:

=CONCAT(A1, " ", B1, " is ", C1, " years old.")

Sample Data:

Exercise: Use the CONCAT function to combine the values in Column A and Column B into a single column, Col3, with a hyphen (-) in between.

Sample Data:

Output:

Exercise: Write a formula using the CONCAT function to create a new column that contains the product name, quantity, and price, separated by a comma and a space, in the following format:

Product name, quantity, price

Sample Data: