قالب وردپرس درنا توس
Home / Tips and Tricks / How to separate the first and last name in Excel

How to separate the first and last name in Excel



Excel can be used for so much more than formulas and data management. It is also an excellent way to manage your contacts. However, you may need to know how to separate first and last name in Excel.

If you import all your contacts from another source, you will likely get a first and last name in a single cell. There is nothing wrong with that, but by separating the two, you can organize them better. Here are some steps to get started.

Separate first and last names in Excel:

We start with our fake contact sheet. You will notice that each person's name, email address and company is displayed. None of these email addresses are real, in case you wanted to email Luke Skywalker.

1. The first thing we need to do is add an empty column that we will use for the surnames. To do this, select column B.

  separate names excel from 1

2. Now right click and look for the option Insert . Select Insert to add the empty column.

  individual names excel 2

3. Select the top of the column with your names in it. In our example that means column A. Now make sure you have the tab Data open.

  individual names excel 3

] 4. Click the button Text to columns . This should open a wizard menu.

5. From the menu, select Separated . This identifies the individual names using tabs or spaces between them.

  separate names excel from 4

6. On page two of the wizard, deselect the tab and select Space . At the bottom you should be able to see an example of where Excel will distribute your data.

  separate names excel 5

7. Go to page three of the wizard and select Finish to apply your changes.

  separate names excel from 6

8. Finally, update the column headings to indicate that the first and last name are now separated.

  separate names excel 7

Now you know how to separate and surnames first in Excel. Your contact lists will never be the same and it should now be easier to search for contacts. You can also sort your list alphabetically if you want to be even more organized.

What else can I do in Excel?

Now that you are in charge of your contact list, you may be ready to expand your Excel skills even further. A little formal training can go a long way and save you time during the day. If you are ready to take it to the next level, you may be interested in a learning pack that we are now highlighting.

It is called the Professional Microsoft Excel Certification Training Bundle and contains a total of 45 hours of hands-on content. You can practice general business functions such as data analysis and graphing, or you can just dive into the basics. Excel is an important part of many careers, so it can give you a head start on a bit of practice.

  pro excel courses

The eight courses in total in the Professional Microsoft Excel Certification Training Bundle have a combined retail value of $ 1,600, but you can buy them now for only $ 39. More than 4,000 other people have already started studying, so you can join them right away.

View details below.

$ 39 .00

The Professional Microsoft Excel Certification Training Bundle

Save $ 1561 .00

Buy Now [19659042] The Professional Microsoft Excel Certification Training Bundle Buy Now

Save $ 1561 . 00 $ 39 .00


Source link