CONCAT Function Explained
The CONCAT function in Microsoft Excel combines two or more strings of text into one string. It takes up to 255 arguments, which can be text, numbers, or single-cell references, and returns a combined string. It is useful for combining data from multiple cells into one cell.
CONCAT Function Syntax
CONCAT(text1, [text2], ...)
- text1: The first text string to be joined together.
- text2: (optional) Additional text strings to be joined together.