Excel 2016 consolidating cells
You can still use the CONCATENATE function, however Microsoft recommends using CONCAT.
CONCATENATE may not be available in future versions of Excel.
For example, you might have established a design for your monthly sales-tracking workbook.
When you have settled on a design for your workbooks, you can save one of the workbooks as a template for similar workbooks you will create in the future.
To ensure that every year’s workbook has a similar appearance, you can create a workbook with the characteristics you want, and save it as a pattern, or template, for similar workbooks you will create in the future.
Simply specify which cell goes first, the text you want (if any) in the middle, inside quotation marks, and then specify the second cell.
TIP You can also save your Excel 2016 workbook either as an Excel 97–2003 template (.xlt) or as a macro-enabled Excel 2016 workbook template (.xltm).
For information about using macros in Excel 2016 workbooks, see Chapter 12, “Automate repetitive tasks by using macros.” When you create a new workbook by using the tools found in the Backstage view, the New page displays the blank workbook template, built-in templates, a search box you can use to locate helpful templates on Office.com, and a set of sample search terms.
Excel 2016 gives you a wide range of tools with which to format, summarize, and present your data.
After you have created a workbook to hold data about a particular subject, you can create as many worksheets as you need to make that data easier to find within your workbook.