How To Separate Names In Excel
If you need to separate names in Excel, follow this guide, and we’ll show you how. Separate Names in Excel To separate first and last names into different columns in Excel, do the following: Select all of the full names from the sheet you want to separate. Make sure not to select any headers – just the names. Click on the Data tab on the ribbon and then click Text to Columns....