By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
Combine text from two or more cells into one cell
Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 More...
You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.