Excel Split Names Tutorial

[@mariourbano2234]

Dude, just wanted to say that you're frickin' awesome, you've saved me a lot of time and taught me so much in so little time than any teacher did in High School and College! Thanks a lot!

[@sekape4868]

I always spend night and night learning from you , My lord bless you so much

[@ouahibabela8986]

Thanks a lot of what you’re sharing with us. Am watching you from Algeria 🇩🇿. All my greetings.

[@SmellLies]

You are the best KZbin teacher on applications. Thank you so very much!!!!!

[@amandawitkowski1031]

This just saved me a good couple hours!

[@Junjo11]

I cannot thank you enough. Thank you. Thank you. I did not know this feature exist.

[@McFourSeasonsDiscovery]

Wow! I've searched videos and watched some. This so far was the very practical and simplified, easy to understand tutorial. Thanks! 😀

[@elinat6993]

Thank you! This is very useful. For example, when importing bank data.

[@ruleoftwo6437]

Hello sir, thank you so much for making these videos. I am binge watching them right now and taking notes. Mind...is blown LOL thanks again.

[@annedalla4301]

I love all of your excel videos. Thank you

[@metrivers1]

Omg, the perfect tutorial that covered the exact thing I was looking to do and not go 45 minutes to show me! That is why I subscribed. Thank you

[@MontyKReed]

This video helped me more than the other videos I watched. Thank you.

[@mkhizedb5692]

true

[@just_toko]

It worked! Simple to understand and follow! I loved it! Thak you so much

[@JoseGarcia-ef5xy]

Exactly what I was looking for! Many thanks my friend!

[@genevieveaciro638]

Thank you, you just saved me hours of work. Thanks

[@crisbergere7788]

This is so far the simplest and easy to follow video on this topic, good job and thank you!

[@jenniferluettinger9871]

Clear concise instructions. Thank you!

[@gwendolynlittle56]

WOW, I have always been afraid of Excel and basically fudge my way through it. You have made this so simple. Thank you so much.

[@youngnewdad8827]

Bro thank you you just saved me hours of data input....ima subscribe!!!

[@stopdrinkingleftskoolaid6510]

You can also use “flash fill”. In column B1, just type the fist name then in column B2, type in the first name again. Flash fill recognizes the pattern and will “flash fill” the rest of the column for you. You can move the B column over and repeat the process for the last name. Flash fill should ignore any delimiters since you didn’t type them into the cell

[@NG72405]

Whew. Had 1900 names in excel. Thanks sooooo much for saving me all this time.

[@williamfaulkner763]

Quick, informative, and helpful. Thanks dude...

[@ma.rachelmiguel4686]

Very helpful!!!! thanks a lot! God bless you, Sir!

[@darlenepetrie8285]

WHOA!!! That was so easy. THANK YOU!!!😍😍😍

[@ivanpantic185]

Great and simple explanations in all of your tutorials. What is missing is sample tables for exercises.

[@nowandforeverflowersanddec8144]

Thank you so much! This saved me so much time.

[@handanagbasradosh1977]

Easy to follow great tutorial! I'm so happy to learn this trick. Thank you

[@sofiasabrina3584]

Thanks for that! The way you teach is amazing!!

[@tasz6152]

THANKS FOR SAVING ME, SUBSCRIBED!

[@clairescott5411]

I love everything that you're doing.

[@DavidJJames]

Ten lepers were cleansed, one came back to say thank you. Ten excelers were helped, and one comes back to say thank you. THANK YOU!

[@evameee7562]

I have been splitting name manually for 20 years now grrrrr but you saved me to split them the next 25 years ;-)

[@ramysami]

You also taught me that Ctrl+E (flash fill) also works. You are a great teacher sir.

[@MSG9876]

A life-saver...thank you much!!!

[@adnanmukbel7128]

Thanks saved me a lot of time!!!!

[@saintbalong3156]

Thank you for this wonderful lesson. ❤

[@stephaniemolina5046]

Thank you so much! This was very helpful, subscribed. I enjoy excel tips and tricks for data and reporting such as formulas etc. You saved me a lot of time and they went straight to the point! Efficient.

[@veramoralez7870]

Great teacher here!!!👍

[@cyneilgersoncruz3510]

Very helpful. Thanks!

[@WakeCountyHomeBuyers]

Great tutorial. Straight and to the point--thank you!

[@minhae970524]

Thank you for the amazing tutorial!

[@ctoumi2]

Excellent tutorial and thank you for sharing :)

[@monikamhatre9932]

Very Helpful...Thank uhh so much

[@Derekivery]

2 hours of my life you have saved me.

[@lebogangsambo2926]

Thank you so much. really helpful we also need the one for triplets

[@hs1943]

Thank you , very helpful tutorial and great technique , appreciate that

[@misa2420]

simple and useful 👌

[@gruscoe]

Very nice video, simple and concise (also solved my problem easily)... Thanks :)

[@yusvarietytv6876]

amazing, and easy techniques.. thank so much for saving my huge time, i watched a lot but it makes me confuses and long formula, for yours is really...Wow keep up a brilliants work.!

[@melodytorres6438]

Thank you for this helpful video. Super helpful!

[@barbk6289]

Thank you, this was Great and saved me so much time!

[@mohammadabusayeed7259]

Dear Sir, this video will help me. Thanks.

[@collinsnzuya999]

Thank you a million times

[@angelitasantos2348]

This is awesome. Thank u so much....

[@BreeandBlake]

Great tutorial

[@jumisekoni1470]

Thank you so much! Live saver

[@donaldconvery4687]

Great video!

[@creativechristiancontent]

Very easy to understand thanks

[@comforttimeheatingcooling8212]

Just skip to minute 1:43 for info you need

[@1JGale]

Thank you, you just saved me alot of time!

[@ndelpurg]

many thanks i watched all please more !

[@WakeCountyHomeBuyers]

You saved me a bunch of time as well! Thank you for sharing!

[@alexandrachivu1147]

THANK YOU soo much!!!!!

[@radykung4376]

very useful. thanks

[@thecalendarninja]

😮Brilliant 👌

[@smuq7359]

English is not my native language.... but your videos are so simple to understand... thank you so much!

[@simonnebritto5108]

This was great!

[@melanieafable7016]

sir this is very useful. May I know what to do if the name is composed of 2 like "Mary Anne" ?

[@daveh1819]

So I have a column of mixed names. Some have middle names or initials, some just have first and last. So what I end up with is column B with last names and middle names, and column C with some last names, and some blanks. Is there a way to set the tool to go from right to left so all last names would be in the same column?

[@rodchamberlain4275]

Easy to follow

[@경지은-s8b]

this is really helping me thanks~~!

[@RCOmega]

You’re videos are amazing! Any way to do this, but reverse? For instance, if I wanted to take two columns and reduce it to one column separated by a comma let’s say?

[@subratadutta7710]

Please share the excel sheets so that we can try with ease. By the way, Good tutorials. Thank You.

[@yuta1696]

Love you thanks

[@Pre726]

This technic knows every one tell us if there is without comma how someone will split

[@leithagrover9116]

Thank you

[@divyansuagarwal]

Hey love your videos but can you use spreadsheets bigger in size, like thousands of rows. It gives a more practical approach and it makes it easy when we encounter large spreadsheets. Cheerrs!

[@Balsero-qb9gv]

Thank you very much for this video!! I have a question please, how can I separate the names if they have a minus symbol (-) in between? Example: John-Smith Thank you so much!!

[@1JGale]

Thank you!

[@arullathaambrose4187]

thanks sir.

[@hpftv3578]

VERY USEFULL THANK YOU

[@goodfay]

so grateful

[@pawjeppesen-ifttttricks605]

Great video(s), you are doing. You are werry good at teaching. Keep up the good work! What if I want to do the opposite, like a sheet where i have a songtitle in column a and artist in b, and want to “merge” those two, in order to export to say Spotify? Sometimes the exporting is messed up, if a song is made by more than one artist. Thanks //Paw

[@sarcasmo57]

You just saved me so much time!!!!!!!!!!!! Thank you, go buy yourself something nice. But wear a mask.

[@kriskuhn7524]

Thank you!!!!

[@CornerstoneTint]

Not all heroes wear capes - THANK YOU!

[@glisten_skin]

Nice video

[@karenmiller9984]

thank you!!!!!!!!!!

[@teddyw.charawa8989]

You are great

[@ComputerHelpHawaii]

Can't you just drag that column to the right? Thanks for the video. Very clear audio.

[@ecolesed1236]

if i have it already splitted , how do i unsplitted? thanks

[@roberthemmelgarn6884]

Great explanation. In a list that I have, some names have a salutation other do not, how are they separated. i.e. Mr. Johnny Jones, Sammy Smith

[@sharonmoore8501]

Great tutorial, but what if some of your names have middle initials?

[@nishantsabale8735]

Thanks a lot :)

[@priyaamit4082]

What Version is your computer?

[@maryvonef]

Hi, if I want to do the contrary, that is make the two collumns of name and surname into one collumn how do I do? thanks

[@vontemarquise4218]

You are a beast

[@amiaragodwin]

This awesome

[@MsEriKaT]

Will this work in Google Sheets??

[@nikhilparikh935]

i have two (A & B) columns with different name but some are same name so my question is how to separate similar name column (C) ?