Excel Split Names Tutorial

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

Thank you a million times

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

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

very useful. thanks

😮Brilliant 👌

Thank you for this wonderful lesson. ❤

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

Not functional, because no example where is more than one last name

The problem with my data is that the name has 4 words :(

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 🙏

Love you thanks

Clear concise instructions. Thank you!

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

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

Great teacher here!!!👍

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

What Version is your computer?

THANK YOU soo much!!!!!

I followed the instructions but I get a pop up saying "There's already data here. Do you want to replace it?"

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 so much. really helpful we also need the one for triplets

Hello, can you help me , hoe to split Total number of cases reported in the last 7 days and 24 hours by country

Very Helpful...Thank uhh so much

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

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

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

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

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

ive done this but i lost some more datas ??

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!

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

I love everything that you're doing.

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

Dear Sir, this video will help me. Thanks.

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 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!!

simple ALT+A+E+E thank me later!

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?

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

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

This awesome

Thank you for the amazing tutorial!

Omg i love u

Thank you so much! Live saver

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

Thanks saved me a lot of time!!!!