Table of Contents
About
The Excel CONCATENATE function is a TEXT Function that can be used to combine text strings.
CONCATENATE function can handle up to 255 individual arguments.
Function Type
Text
Purpose
Combine data
Return value
Concatenated data (Text joined together)
Syntax
=CONCATENATE(text1, [text2], ...)
Arguments
text1 – The first text value to join
text2 – [optional] The second text value to join.
Examples
Notes
From Excel 2019, CONCAT function replaces CONCATENATE function. However, CONCATENATE function will stay available for the compatibility of earlier versions of Excel.
TEXTJOIN function another Excel function which can be used to combine text strings.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)