Excel CONCATENATE Function allows you to combine or concatenate multiple text strings into a single string. It’s like putting together pieces of a puzzle to create a complete picture.
Syntax
CONCATENATE(text1, [text2], …)
Arguments
| text1 | The first text or string you want to combine. |
| [text2] | (Optional) Additional text or strings you want to join. You can add more text by including text2, text3, and so on. |
How to use
Let’s say you have two cells in Excel, A1 containing “Hello,” and B1 containing ” world!” To combine these two strings into one cell, you can use the CONCATENATE function in cell C1. Here’s how you do it:
|
1 |
=CONCATENATE(A1, B1) |
This will result in the content of cell C1 as “Hello, world!”
You can also concatenate more than two strings. For example, if you have text in cells A2, B2, and C2, you can combine them using:
|
1 |
=CONCATENATE(A2, B2, C2) |
Excel will merge the contents of these cells into a single string.
Examples
Let’s explore some more examples to understand how CONCATENATE works:
|
1 |
=CONCATENATE("I", " love", " Excel") |
This formula will result in “I love Excel.”
|
1 |
=CONCATENATE(A1, ", it's a", B1) |
If A1 contains “Hello,” and B1 contains ” beautiful day!”, this formula will give you “Hello, it’s a beautiful day!”
Remember, you can use this function to combine text from different cells, add spaces, punctuation, or any other characters you like.
Additional information
The CONCATENATE function is a useful tool when you need to create custom labels, sentences, or any text combinations in your Excel worksheets. It simplifies the task of merging text and is commonly used in various Excel projects. If you encounter any unfamiliar terms or need more details about Excel functions, you can refer to the Microsoft Excel support page.