Excel 2016 consolidating cells
If you establish a pattern by typing the full name in column C, Excel's Flash Fill feature will fill in the rest for you based on the pattern you provide.
is designed to provide participants with a fundamental understanding of the Excel environment and the ability to complete tasks using calculations, graphing tools, pivot tables and more.
If you wish to become certified, this course prepares you for the Microsoft Excel 2016 certification exam.
Who it's for: Anyone currently using Microsoft Excel, or anyone who wants to learn how!
That way, Excel will update the value for you whenever you open the workbook.
If multiple worksheets hold related values, you can use links to summarize those values in a single worksheet.