Your contact lists will never be the same, and it should be easier to search for contacts now. Now you know how to separate first and last names in Excel.
Finally, update the column headers to reflect that first and last names are now separate. Move onto page three of the wizard and select Finish to apply your changes.Ĩ. At the bottom, you should be able to see an example of where Excel will divide your data.ħ. On page two of the wizard, deselect tab and select Space. This identifies the separate names using tabs or spaces between them.Ħ. Now make sure you have the Data tab open.Ĥ. Select the top of the column with your names in it. Now right-click and find the Insert option. The first thing we need to do is add an empty column that we will use for the last names.
None of these email addresses are real, just in case you were hoping to email Luke Skywalker.ġ. You’ll notice that it shows each person’s name, email address, and business.
We’ll start off with our fake contact sheet. How to separate first and last names in Excel:
0 kommentar(er)
