CONCATENATE
The CONCATENATE function combines multiple strings or cell values into a single string. It is used for merging text data within a worksheet.
Example explanation
We use the CONCATENATE function in column C to combine first names and last names from columns A and B.
Syntax 🔗
=CONCATENATE(text1, [text2], ...)
text1 | The first text or cell reference to be concatenated. |
[text2] | Additional texts or cell references to be concatenated. You can include up to 255 arguments. |
[...] | Additional texts or cell references to be concatenated. |
[text255] | The last text or cell reference to be concatenated. |
About CONCATENATE 🔗
Use the CONCATENATE function in Excel to join pieces of text or cell contents into a single string. This function is useful for text manipulation, creating reports, or crafting personalized messages within your workbook. Simply provide the texts or cell references as arguments, and CONCATENATE will combine them into a single string. You can merge up to 255 separate elements, making it a versatile tool for combining text.
Examples 🔗
To combine the first name 'John' from cell A1 and the last name 'Doe' from cell B1 into a full name in cell C1, use the CONCATENATE function like this: =CONCATENATE(A1, " ", B1). This formula will produce the combined text 'John Doe'.
For combining numerical values in cells A2, B2, and C2 into a custom label, apply the CONCATENATE function as follows: =CONCATENATE("Item ", A2, "-", B2, " (", C2, " pcs)"). This will generate a concatenated text such as 'Item 101-Red (15 pcs)'.
Notes 🔗
The CONCATENATE function combines text, numbers, and dates into a single string without performing arithmetic operations or date calculations. When concatenating numerical values or dates, consider their formatting and alignment to achieve the desired presentation and interpretation.
Questions 🔗
Yes, the CONCATENATE function can join up to 255 individual cell values or texts into a single concatenated string.
How can I include spaces or punctuation in the concatenated output using the CONCATENATE function?You can include spaces, punctuation, or any constant characters within the CONCATENATE function by enclosing them in double quotation marks. For example, to include a space between two concatenated cell values, use the formula: =CONCATENATE(A1, " ", B1).
What happens if one of the arguments in the CONCATENATE function is an empty cell?If one of the arguments provided to the CONCATENATE function is an empty cell, it will be treated as an empty text string, and the function will proceed to concatenate the non-empty arguments as usual.