CONCATENATE Function - Excel
Overview
The CONCATENATE function in Excel is a useful tool for combining multiple text strings into a single string. It simplifies the process of joining together various pieces of text and allows you to combine up to 255 text strings.
Example:
=CONCATENATE("Apple", "Cat")
Syntax:
=CONCATENATE(text1, [text2], ...)
text1, text2, ...: These are the text strings you want to combine. You can include up to 255 text arguments.
Example: Using a Delimiter or hardcoded value
In this example, I manually inputted the delimiter, “-”, between Word 1 and Word 2. You can either reference a cell where the delimiter is located or you can manually input it into your CONCATENATE function. In order to manually add a delimiter or any other hardcoded value, you need to include it in double quotation marks (““) within the CONCATENATE function.
