How to Use CONCAT Function in Excel | Excel Formula Guide

Learn how to use the CONCAT function in Excel to join text from multiple cells. Includes syntax, examples, and tips for efficient text handling.

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: