Use CONCATENATE, CONCAT, TEXTJOIN or the & operator in Excel to concatenate (join) two or more text strings.
The CONCAT function combines multiple text strings or cell values into one string, supporting dynamic data merging. Parameters: text1, text2, ...: The text strings, numbers, or cell references to combine (up to 255 arguments). Note: In older Excel versions, use CONCATENATE with the same syntax.