Learn how to use the CONCAT function in Excel to join text from multiple cells. Includes syntax, examples, and tips for efficient text handling.
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:
Exercise:
=CONCAT(A1, " ", B1, " is ", C1, " years old.")
Sample Data:
| Column A | Column B | Column C |
|---|---|---|
| Muhammad | Ali | 20 |
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:
| Column A | Column B |
|---|---|
| Muhammad | Ali |
| Muhammad | Hamza |
| Nasir | Ahmad |
Output:
| Column A | Column B | Column C |
|---|---|---|
| Muhammad | Ali | Muhammad Ali |
| Muhammad | Hamza | Muhammad Hamza |
| Nasir | Ahmad | Nasir Ahmad |
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:
| product Name | quantity | price |
|---|---|---|
| Apple | 100 | 5 |
| Banana | 200 | 4 |
| Orange | 300 | 3 |