CONCAT function | Microsoft Support
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments. CONCAT replaces the CONCATENATE function.
Combine text from two or more cells into one cell in Microsoft Excel
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
CONCATENATE function | Microsoft Support
In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you …
Combine text and numbers | Microsoft Support
When you do combine numbers and text in a cell, the numbers become text and no longer function as numeric values. This means that you can no longer perform any math operations on them. To …
How to correct a #VALUE! error in the CONCATENATE function
In newer versions of Excel, Excel Mobile, and Excel for the web, CONCATENATE has been superseded by the CONCAT function. Although CONCATENATE is still available for backward compatibility, you …
Text functions (reference) | Microsoft Support
Learn more about the differences. Lists Text functions, such as the Clean, Proper, and Trim functions.
TEXTJOIN function | Microsoft Support
The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this …
Combine first and last names | Microsoft Support
In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you …
Excel functions (by category) | Microsoft Support
Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed …
Combine data from multiple sheets | Microsoft Support
Excel offers several ways to do this, depending on whether you want to summarize values or simply combine lists. Make sure your source data is well structured. Use a list format (no entirely blank rows …
Combine text with a date or time | Microsoft Support
To combine text with a date or time, use the TEXT function and the & (ampersand) operator.