Combining or merging the first and last names in an Excel spreadsheet or workbook requires ... If you want to ignore empty cells, then please change the False value to True. Finally, we want ...

In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods are still valid in Excel 2013, but the combined ...