How to Combine First and Last Names in Microsoft Excel
To merge first and last names in Excel, type the first combined name how you’d like it to appear, then use Flash Fill to combine the rest of the names automatically. Alternatively, get finer control by combining your name cells using a formula or the Power Query tool.
Do you want to bring the first and last names that are in separate cells into a single cell? Combining text is easy in Excel, and we’ll show you five different ways to combine names.
Method 1: Use Flash Fill
Flash Fill is an Excel feature that automatically fills your cells by recognizing the fill pattern. You manually fill a cell with the kind of data you want, and the feature senses that data and fills all your selected cells accordingly. No formula is necessary with Flash Fill.
In the case of combining names, you manually merge the first and last names for a single record, and Flash Fill recognizes that pattern and merges the names for all your other records automatically.
To use start using Flash Fill, in your spreadsheet, select the first cell where you want…
Read Full Article Source