The fastest way to separate first and last name in Excel, only 8 clicks and done!

There are many ways to separate first and last name in Excel. You should use the Text to columns feature because this is the feature that was born to do just that.

The fastest way to separate first and last name in Excel, only 8 clicks and done!

If you are having a data table that is a collection of lists of many people whose full name information is only on a single column while your requirement is to separate the first and last name information into two other columns What you need to do is copy that data table into an Excel file because separate first and last name in Excel very simple.

Advertisement

How to separate first and last name in Excel 2003, 2007, 2010, 2013…

  1. Add a blank column next to the first and last name columns by right-clicking at the top of the column, selecting Insert.

The fastest way to separate first and last name in Excel, only 8 clicks and done!

2. Select the Data tab.
3. Click on the top of the column containing the first and last name information.
4. Select “Text to columns” as shown below.

Advertisement

The fastest way to separate first and last name in Excel, only 8 clicks and done!

5. Select Delimited and click Next.

Advertisement

The fastest way to separate first and last name in Excel, only 8 clicks and done!

6. Uncheck the Tab box and tick the Space box as shown.

The fastest way to separate first and last name in Excel, only 8 clicks and done!

7. Select Finish.

The fastest way to separate first and last name in Excel, only 8 clicks and done!

8. Edit the title of the two columns of first and last name information that have just been separated.

The fastest way to separate first and last name in Excel, only 8 clicks and done!

Note: Hyphenated compound phrases are treated as a single word by Excel, so it separates the compound phrase by hyphen. For example, “Lee Kwang-soo” is a two-word name but “Yoo Jae Suk” is a three-word name, even though both are pronounced with three syllables. If the list contains the first and last name information including 3 words, 4 words or more, the number of empty columns you need to add in step 1 will increase accordingly.

See more:  Quickly download Pathfinder: Kingmaker for free on EGS

So GhienCongList has finished guiding how to separate the first and last name in Excel. Don’t forget to like and share if you find it useful. For more Excel tips and tricks please click here. Good luck!

Reference Constantcontact

You may need to know:

Source: The fastest way to separate first and last name in Excel, only 8 clicks and done!
– TechtipsnReview

, , ,

Leave a Reply

Your email address will not be published. Required fields are marked *