Excel Split Names Tutorial
HTML-код
- Опубликовано: 15 окт 2017
- 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!
This just saved me a good couple hours!
Easy to follow great tutorial! I'm so happy to learn this trick. Thank you
Wow! I've searched videos and watched some. This so far was the very practical and simplified, easy to understand tutorial. Thanks! 😀
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
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.
This is so far the simplest and easy to follow video on this topic, good job and thank you!
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.
Great tutorial. Straight and to the point--thank you!
Thanks a lot of what you’re sharing with us. Am watching you from Algeria 🇩🇿. All my greetings.
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
Thank you , very helpful tutorial and great technique , appreciate that
Great and simple explanations in all of your tutorials. What is missing is sample tables for exercises.
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.
Excellent tutorial and thank you for sharing :)
I love all of your excel videos. Thank you
simple and useful 👌
Thank you for this helpful video. Super helpful!
Thanks for that! The way you teach is amazing!!
You saved me a bunch of time as well! Thank you for sharing!
Clear concise instructions. Thank you!
many thanks i watched all please more !
You are the best RUclips teacher on applications. Thank you so very much!!!!!
You also taught me that Ctrl+E (flash fill) also works. You are a great teacher sir.
Thank you, this was Great and saved me so much time!
Thank you, you just saved me alot of time!
Very easy to understand thanks
Quick, informative, and helpful. Thanks dude...
Thank you for the amazing tutorial!
This video helped me more than the other videos I watched. Thank you.
true
Exactly what I was looking for! Many thanks my friend!
I love everything that you're doing.
Thank you so much! This saved me so much time.
Very helpful!!!! thanks a lot! God bless you, Sir!
Thank you for this wonderful lesson. ❤
It worked! Simple to understand and follow! I loved it! Thak you so much
A life-saver...thank you much!!!
Thank you so much. really helpful we also need the one for triplets
Very Helpful...Thank uhh so much
so grateful
Bro thank you you just saved me hours of data input....ima subscribe!!!
VERY USEFULL THANK YOU
I have been splitting name manually for 20 years now grrrrr but you saved me to split them the next 25 years ;-)
Thank you, you just saved me hours of work. Thanks
Great video!
WHOA!!! That was so easy. THANK YOU!!!😍😍😍
This is awesome. Thank u so much....
Very nice video, simple and concise (also solved my problem easily)... Thanks :)
very useful. thanks
I cannot thank you enough. Thank you. Thank you. I did not know this feature exist.
Great tutorial
this is really helping me thanks~~!
Thanks saved me a lot of time!!!!
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?
Thank you!
THANK YOU soo much!!!!!
Whew. Had 1900 names in excel. Thanks sooooo much for saving me all this time.
Thank you a million times
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!
Thank you sir!
This was great!
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.!
Thank you
Love you thanks
Thank you so much! Live saver
😮Brilliant 👌
THANKS FOR SAVING ME, SUBSCRIBED!
Great teacher here!!!👍
THANK YOU!!!
thanks sir.
Easy to follow
Thank you!!!!
Dear Sir, this video will help me. Thanks.
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!!
thank you!!!!!!!!!!
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
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
Thanks a lot :)
You are great
This technic knows every one tell us if there is without comma how someone will split
This awesome
Nice video
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
My entire life has been a lie. You just blew my mind. Thank you so much!! Great quick video that is so helpful!!
Can't you just drag that column to the right? Thanks for the video. Very clear audio.
Awesome
You are a beast
2 hours of my life you have saved me.
if i have it already splitted , how do i unsplitted? thanks
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!
English is not my native language.... but your videos are so simple to understand... thank you so much!
sir this is very useful. May I know what to do if the name is composed of 2 like "Mary Anne" ?
Omg i love u
Not all heroes wear capes - THANK YOU!
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?
What Version is your computer?
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 🙏
How can you separate the first name with space like Fernandez, John Daniel?
I use a Mac at home and my school provides its staff with Microsoft online, so the Excell version I have is very limited