How to Separate Names in Excel

No video

How to Separate Names in Excel

Рет қаралды 167,144

Күн бұрын

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.
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert...
As full disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 165

@KevinStratvert 3 жыл бұрын

🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@JenniferDonow 5 ай бұрын

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!

@jeffreyschmidt179 3 жыл бұрын

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

@nancyesc7624 2 жыл бұрын

Thank you!! I was already about to shed a tear

@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! 🙌🏾

@nextgengaming6614 16 күн бұрын

Thank you I didn't know it would be this easy

@MortgageMentorAsher Ай бұрын

you saved me hours of work

@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.

@scarpoochie 3 ай бұрын

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

@bernadettepesce7044 2 ай бұрын

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

@coolpool5277 Жыл бұрын

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

@jialinang8270 Жыл бұрын

Oh my god, for the past few year I have been separating it manually!

@maichannel1050 4 ай бұрын

This works wonders! Thank you so much!

@user-np8kx2my4h 2 ай бұрын

Life Saver, so quick!

@Highly5favoured 6 ай бұрын

Thank you so much for sharing this tip.

@mulavangue Жыл бұрын

THANK YOU VERY MUCH FOR SHARING THIS TIP.... YOU SAVED MY DAY.

@melsazaspanishmark7994 2 ай бұрын

The Ctrl E worked thank you

@Monika-nb6ur 3 жыл бұрын

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?

@deepanshusood 2 жыл бұрын

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

@chenkeith7272 4 ай бұрын

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

@ven2300 4 жыл бұрын

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 KZfaq Thumbnail and design Things! Thanks much!!

@JoseCarlos-xs1ew 2 жыл бұрын

Very useful! From Angola, you saved my day!!!

@xiafernandez6961 4 жыл бұрын

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.

@natraj4903 3 жыл бұрын

Probably the easiest method i have seen. Thx Kev

@cindywright1564 Жыл бұрын

thank you, thank you, thank you, thank you to the umpteenth power!

@joshuaosoriobearriver6815 Жыл бұрын

thank you sir. great help. God Bless

@HoneyMrsBons Жыл бұрын

I've watched this a minute ago, and Wow it really works. Thanks

@babble54 3 жыл бұрын

You just saved my time from using formulas. Thanks a ton!!

@marianezulueta8999 3 ай бұрын

Thank you so much, super helpful ❤

@jarvisadamsedu4270 Жыл бұрын

You saved me a boat load of time. Thank you!

@memel2853 7 ай бұрын

Great video. Quick and simple. Thanks

@cammarshall2376 Жыл бұрын

I love this guy and my Microsoft Guru

@jenniferdonow5036 10 ай бұрын

This was super helpful.

@aliala9844 3 жыл бұрын

You saved me Man. Thank you.

@TimTomkiewicz 4 ай бұрын

amazing Kevin you are my hero

@johnpadgettii9998 Жыл бұрын

Thank you and well done!

@nonethorito3161 6 ай бұрын

it really works..thanks for the help!

@osrsyambo Жыл бұрын

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

@questionresearch8721 2 жыл бұрын

Thank you this helps so much ❤️

@chinita1pr 3 жыл бұрын

Best tip ever. Text to columns is a PITB.

@beverlygilalta1420 9 ай бұрын

Thank you as always

@KmmBev 7 ай бұрын

Your videos are so awesome Kevin! I knew there was a simple way- thank you🎉!

@HoneyMrsBons Жыл бұрын

I have difficulties on formulas thanks I found your Videos

@jamalwhitney8203 4 ай бұрын

saved me a ton of time. thank you!

@LilkaDP 4 ай бұрын

THANK YOU! this was so helpful!

@joshthielbar1 Жыл бұрын

This was awesome. Thank you

@Mooshoes 8 ай бұрын

Thank you for the tips here, you explained it very well.

@danaredford5782 3 жыл бұрын

How cool, just had a need and it worked like a charm! Thanks for sharing!

@chongomwila7746 Жыл бұрын

Worked super easy. Thank you

@mickeydeadeyes7686 11 ай бұрын

Just saved me like an hour...amazing!

@lindacostner8225 3 жыл бұрын

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!

@gustavodfwrealtor Жыл бұрын

EXACTLY WHAT I NEEDED! 🙏🏼👏🏼✔️

@pedroSoldit Жыл бұрын

Excellent info, super easy to follow and understand. Thank you very much

@yonasmisganaw6023 2 жыл бұрын

Thanks bro the easiest i have seen!

@A.E.Carrillo Жыл бұрын

Great alternative! Thank you! I was about to use the formula method!

@creativecards4u Жыл бұрын

IT WORKED OF MY STARS !!!! THANKYOU SO MUCH!!!! ♥🤩

@Houston87651 10 ай бұрын

Thank you for this video, it was SUPER helpful.

@ossieocasio-falu4278 10 ай бұрын

very helpful thanks

@SNeaker328 11 ай бұрын

Something I have not been able to find anywhere is how to separate out the names when there are two names in the same cell, for instance a married couple that has two last names like "Smith, Mike & Johnson, Emma."

@1969jflo Жыл бұрын

Thank you so much, this save me a days work.

@rozayempire6388 8 ай бұрын

It worked, im super elated 🎉

@arrelmaximo8942 Жыл бұрын

You just earned a subscriber.

@jeromelubabalojacobs8872 Жыл бұрын

This was very helpful and easy thanks.

@hoopie1022 Жыл бұрын

Thank you !

@odokonyerorobinson2475 2 жыл бұрын

YOU ARE AMAZING KEVIN I LIKE THAT

@lauracryderman458 4 ай бұрын

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

@timetowatch_francois Жыл бұрын

Saved soooooo much time!!! Thanks for sharing! and ... you're creeping up on 2M Subs!!! 👏🏼🤩 Hope you hit it soon. I know I added my name to your list 😄👍🏼

@ValorantRivals 2 жыл бұрын

Bro, this is amazing.... omg!

@user-ys6xx6dm4w Жыл бұрын

Wow this was incredibly helpful - thank you!

@TheMAX0508 11 ай бұрын

This saved my big time

@m.usmanulasad9403 3 ай бұрын

Brother thanks a looooot.❤❤❤❤❤

@gooddreams369 2 жыл бұрын

Dude you are a life saver

@oritbc4578 Жыл бұрын

Excellent and simple guide. Thx!!

@nancyesc7624 2 жыл бұрын

Loved it, I wouldn't even imagine that as an option! thank you

@RobinGlassey 2 жыл бұрын

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

@frankforcier5848 4 жыл бұрын

This was very helpful, but recently there's a lot of people with two last names. For example, Johnson-Smith or Anderson-Stratvert. It will only pick up the last part of that name.

@nathanfirby2953 3 жыл бұрын

It works if the double- barrelled surname is hyphennated. I've also just realised that it works if you leave it as a range of cells - i.e. there's no need to turn it into a tablel first.

@HappyBeezerStudios Жыл бұрын

@@nathanfirby2953 That would still have issues with names like van Helsing or van Gogh, and obviously names where more than one first name exists.

@nkazindlov9689 10 ай бұрын

You are a life saver

@28peas 2 жыл бұрын

Hey, thanks a ton for that great trick! Ps- In my case, I got the middle name & the last name together in the Lastname column. But it worked & saved me a lot of time. Thanks.

@mannyvidis4533 11 ай бұрын

Hi Kevin I am a recent convert to your web site and you've helped out of several jams. Now I have one that has totally stymied me. A friend of mine wants me to address 150 envelopes for her son's wedding which sounds simple enough but the list she is going to send me is in word and as far as I know it has no formatting. I think she just types an address then skips a line and types another address, etc. I thought and thought about it but can come up with any way to make a spread sheet that I can use to address the envelopes. Your advice will be gratefully received. Thanks. Manny-

@kayjayteewol Жыл бұрын

Woooooooow! Impressive! Thank you so much for this tutorial. It really helped me save time and energy. Thank youuuuuu =)

@dymierefinch2655 Жыл бұрын

Easiest way I have seen to date.

@terrycontreras3704 Жыл бұрын

Kudos 2/U! great video....🙌❤🙌

@yabinruan Жыл бұрын

I have to Thank you for making this video. It's super useful.👍

@chrissygirl3870 4 ай бұрын

Thank you!!!!!!!!!!!!!!!!!!!!

@lynettehiser6390 2 жыл бұрын

Thank you!!!

@fatemehkamkar3607 Жыл бұрын

You are the best

@solutions4u241 Жыл бұрын

It is a very useful info ,Thank youuuuu

@viktoriyafriedman6087 11 ай бұрын

It’s great, but I have over 10K rows with some Jr. Designations that pulled into Last name column. Also, some double last names..

@pschiavitti6688 Жыл бұрын

Genius!! Thank you!!

@yonasmisganaw6023 2 жыл бұрын

can u make video on how to add two service years put in this format and if i want to add them any suggestion you might have it will be usefull,Thanks 2yrs,2m,2days 3yrs,2m,2days

@mohammadtaqi9028 2 ай бұрын

Excellent

@gerbherb8215 6 ай бұрын

So what do we do with the "Benson" of Margaret Miller? We just forget that it is part of her name? And what if someone has a first name made out of two words? Or a last name made out of two or more words? Or a combination of first and last names with more words? And have you ever seen people who have nobility names?