+3 votes
211 views
How to divide or separate first and last name in Excel 2016

in Office by (552k points)
reopened | 211 views

1 Answer

+4 votes
Best answer

How to divide or separate name with full last names in columns with Excel 2016

Excel 2016 is one of the most powerful data management tools we find today and thanks to its multiple functions we can perform countless tasks on the data supplied regardless of the type that they are..

Many of us when we work with Excel 2016 we are faced with situations that can complicate the work, nothing is perfect, since on several occasions the data provided does not come in a consistent order or the way the file was edited is not correct.

This happens frequently when we work with user names since they leave them in a single cell and for organizational or function issues , for example dynamic tables, it will be necessary that in a cell it is the name and in another the last name..

This tutorial today will analyze how we can divide a cell automatically because it would be an unnecessary waste of resources and time manually.

How to divide or separate name with full last names in columns with Excel 2016


Step 1

We have the following information: image
Step 2

Our goal is for the user's name to be in the Name column and the last name in the Name column.
First we will select the range of cells to edit and we go to the Data tab, Data Tools group and there we select the Text button in columns: image
Step 3

Pressing on said option will display the following:

image

Step 4

There we activate the Delimited box and click Next. In the next window we must define the separator of the cell content, in this case we select Space but we can find cells that inside the data are separated by commas, semicolons or other symbols.

image

Step 5

We can see in the preview how was the final result of our process. We press Next again and in a new window we must indicate the destination where the process will be created:

image

Step 6

There we can click on the right button to select the range where the result will be established: image
Step 7

We can also enter it manually . Press again on the final button and in the window that opens click on Finish . We can see the desired result: image

If you have any questions, take a look at the video with all the steps described for pdoer didivir a full name in columns with surnames in Excel 2016..

To stay up to date, remember to subscribe to our YouTube channel! SUBSCRIBE

Now we can simply delete the source content and work with the new data structure. In this way Excel 2016 simplifies our data management tasks. Here we also offer you more information on how to divide complete names and order the cells by Excel 2016 color.

Divide Excel names


by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Oct 24, 2022 in Office by backtothefuture (552k points) | 77 views
+5 votes
1 answer
+5 votes
1 answer
asked Sep 17, 2019 in Office by backtothefuture (552k points) | 225 views
+5 votes
1 answer
+3 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users