How to Separate Names in Excel

Easily separate First Name from Last Name in Excel, including if there are middle names, and with no formulas. Simply use tables and fill series to separate the first name from the last name. In this video, I use the latest version of Excel that comes with Office 365.

As full disclosure, I work at Microsoft as a full-time employee.

[JenniferDonow]

Because I can be a tad slow, I have come back to this video several times. It is super helpful, plus Kevin explains things in a way that I hear. Thanks!

[karenmiller]

This was clearest instructions EVER!!! Thank you!

[jeffreyschmidt]

It worked. After I typed the first two names, I hit Control - E. Using on a Mac with Office 365. Thanks!

[Monika-nbur]

I'm​ trying this, but it's not working! It there something with the settings we have to do after changing the data into a table?

[xiafernandez]

How about if the First Name has a Second name for example Reyes, Mary Jane Sanchez how will it separate? the first name that has Second Name (Mary Jane). Thank you.

[osrsyambo]

Is there a way to do this with a formula? Like without using the table?

[DaudiX]

Kevin, I was expecting some complex formula that I have to cram…this is so straight forward I will remember it! Thanks a million! 🙌🏾

[ghenergy]

Kevin thanks for this tip. You are well on your way to becoming a great leader within the technical community. I'm a senior recruiter for one of the larger EPC companies within the industrial construction sector and I deal directly with the VP, Info Mgmt • Project Execution Services within EPC in our company. I'll follow more of your excellent training sessions.

[deepanshusood]

I am trying this on Microsoft 365 for Mac, using Table method and it just won't intelligently detect names.
Okay So I found out instead of Command you are supposed to use control-E and it worked. Thanks a lot for this

[ven]

Hi good day! I don't have a business, I just bought myself a Laptop to learn how to use it with the Internet, I find your videos very Interested and I'm learning a lot so far from U! I would really like to know how to use Power point, Excel and Microsoft Word to do some Online business like helping person with Valuable Contents, Create YouTube Thumbnail and design Things! Thanks much!!

[chenkeith]

I hope to see a countif and also at the same time the cell get color coded or bold as well for those being counted

[coolpool]

Keving, you have no idea how you make lives of people like me so easy. Good on you

[lauracryderman]

Looking for a standardize names to Last, First, (may have a) Initial, from a list of names that are a mix of NAMES, in capital and names with no spaces between the coma and name. list of names are not all the same formats. List of names to standardize: Smith, Bob, SMITH, BOB, Reacher, Jack, Reacher, Jack F, Reacher, Jack F

[christianfamilychurchcentu]

How do I separate First Name from Last Name in Excel on my Mac

[scarpoochie]

This is perfection! Thank you, Kevin, for saving me tons of time today. You're the best.

[cammarshall]

Quick question, what happens if it is last name, e.g Mary Van Der Gough or double barrel last name Brown-Wright?

[RobinGlassey]

Looks like a great idea, but this didn't work for me when I tried it.

[codewithyemi]

It's not working for me. I wonder what could be the problem.

[bernadettepesce]

What a timesaver! I have a huge list that I need to alphasort. Kevin, thank you SO much.

[lindacostner]

Gosh, you are so amazing! I often go to your videos to learn all your helpful tricks for excel. You sure save me a lot of time and make my work a lot easier. Even though you don't know me but You make me look good!