It is very easy to separate the first and last names in Microsoft Excel. Here’s a short tutorial on how to do it:
- Inside your Microsoft Excel worksheet, find and select the entire column containing the list of names you wish to split.
- After that, head over to the top menu bar and click 'Data'.
- Choose 'Split Text to Columns' from the given options.
- Following that, specify the delimiter you use between the first and last names.
- Check the results from the provided preview and then tap 'Apply' to save the changes.
- After completing these steps, the first and last names from the selected list will be separated into two columns.
