CONCATENATE Function Explained
The CONCATENATE Function in Microsoft Excel allows users to combine two or more text strings into one. It takes up to 255 arguments, which can be text, numbers, cell references, or a combination of all three. The function returns a single text string that is the combination of all the arguments.
CONCATENATE Function Syntax
CONCATENATE(text1, [text2], ...)
- text1: The first text string to be joined together.
- text2: (optional) Additional text strings to be joined together.