In Excel 2019 and later, theCONCAT functionandTEXTJOIN functionare better, more flexible alternatives.
The CONCATENATE function accepts multipleargumentscalledtext1,text2,text3, etc.
up to 30 total.
Values may be supplied as cell references, and hard-coded text strings.
Only the first argument is required, and values are concatenated in the order they appear.
To concatenate many values with a common delimiter, see theTEXTJOIN function.
TEXTJOIN can do everything CONCAT can do, but can also accept a delimiter and optionally ignore empty values.
