Excel Split Names Tutorial
Вставка
- Опубліковано 27 сер 2024
- My entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to split names in Excel. Sometimes in Excel you end up with too much information in one column, for example first and last names in the same column. This tutorial will show you how to deal with that and easily split the data into two columns so you can more easily sort and filter the data. #excel #splitnames ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
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!
I always spend night and night learning from you , My lord bless you so much
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
This just saved me a good couple hours!
Thanks a lot of what you’re sharing with us. Am watching you from Algeria 🇩🇿. All my greetings.
Wow! I've searched videos and watched some. This so far was the very practical and simplified, easy to understand tutorial. Thanks! 😀
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.
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.
You are the best UA-cam teacher on applications. Thank you so very much!!!!!
Great and simple explanations in all of your tutorials. What is missing is sample tables for exercises.
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!
You also taught me that Ctrl+E (flash fill) also works. You are a great teacher sir.
This video helped me more than the other videos I watched. Thank you.
true
Whew. Had 1900 names in excel. Thanks sooooo much for saving me all this time.
I cannot thank you enough. Thank you. Thank you. I did not know this feature exist.
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
This is so far the simplest and easy to follow video on this topic, good job and thank you!
I love all of your excel videos. Thank you
Thank you, you just saved me hours of work. Thanks
Exactly what I was looking for! Many thanks my friend!
Dear Sir, this video will help me. Thanks.
It worked! Simple to understand and follow! I loved it! Thak you so much
Clear concise instructions. Thank you!
Thank you so much! This saved me so much time.
Bro thank you you just saved me hours of data input....ima subscribe!!!
Easy to follow great tutorial! I'm so happy to learn this trick. Thank you
Very helpful. Thanks!
Thank you so much. really helpful we also need the one for triplets
Quick, informative, and helpful. Thanks dude...
Thank you a million times
2 hours of my life you have saved me.
Very helpful!!!! thanks a lot! God bless you, Sir!
I have been splitting name manually for 20 years now grrrrr but you saved me to split them the next 25 years ;-)
WHOA!!! That was so easy. THANK YOU!!!😍😍😍
I love everything that you're doing.
Please share the excel sheets so that we can try with ease. By the way, Good tutorials. Thank You.
Very Helpful...Thank uhh so much
My entire life has been a lie. You just blew my mind. Thank you so much!! Great quick video that is so helpful!!
Thank you for this wonderful lesson. ❤
This technic knows every one tell us if there is without comma how someone will split
English is not my native language.... but your videos are so simple to understand... thank you so much!
A life-saver...thank you much!!!
Great tutorial. Straight and to the point--thank you!
Thanks saved me a lot of time!!!!
Thanks for that! The way you teach is amazing!!
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.
Great tutorial
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.!
simple and useful 👌
Thank you for the amazing tutorial!
Thank you , very helpful tutorial and great technique , appreciate that
Excellent tutorial and thank you for sharing :)
Great teacher here!!!👍
This is awesome. Thank u so much....
THANKS FOR SAVING ME, SUBSCRIBED!
Great video!
Very nice video, simple and concise (also solved my problem easily)... Thanks :)
Very easy to understand thanks
Easy to follow
Thank you, this was Great and saved me so much time!
very useful. thanks
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?
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!
Thank you for this helpful video. Super helpful!
Thank you, you just saved me alot of time!
You saved me a bunch of time as well! Thank you for sharing!
sir this is very useful. May I know what to do if the name is composed of 2 like "Mary Anne" ?
THANK YOU soo much!!!!!
Not all heroes wear capes - THANK YOU!
Can't you just drag that column to the right? Thanks for the video. Very clear audio.
many thanks i watched all please more !
if i have it already splitted , how do i unsplitted? thanks
You just saved me so much time!!!!!!!!!!!! Thank you, go buy yourself something nice. But wear a mask.
Thank you
Thank you so much! Live saver
Fab! A coworker sent me a data splitter for dates. So you just put in date so 11/11/22 and it splits it into 3 columns automatically. How do I do that for names without having to go through these steps, is there a way? Thank you 🙏
Just skip to minute 1:43 for info you need
😮Brilliant 👌
so grateful
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!!
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?
Great tutorial, but what if some of your names have middle initials?
VERY USEFULL THANK YOU
thank you!!!!!!!!!!
Thank you sir!
What if there are middle initials or names included?
This was great!
What if people have multiple names? and the names are not separated by a comma.
Some people in my list have like 5 names, and all are just separated by space
Love you thanks
this is really helping me thanks~~!
thanks sir.
Nice video
THANK YOU!!!
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) ?
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
Please help i need to format my data from Andrew Pangson to A Panganson
Thank you!
Sir how about with two first names?
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
How can you separate the first name with space like Fernandez, John Daniel?