Excel 2016 consolidating cells
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!
Let's say column A contains first names, column B has last names, and you want to fill column C with first and last names combined.
In the function, you separate the cells or strings that you want combined by commas.
To add a space between the strings, include a space enclosed in quotation marks (" ").
The intermediate portion shows you how simple it is to sort and filter and then moves to one of Excel’s most popular features, Pivot Tables.
Our advanced videos start with functions like IF and VLOOKUP and finish up with Macros.
You can combine text from two or more cells into one cell.