You are an excellent teacher! I teach over 500 students a week, and needed to view my students in another program in different ways. This clear tutorial saved me over 3 hours of work. Thank you so much!
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!!
How to Separate Names in Excel ► ua-cam.com/video/J1ccouJGB5k/v-deo.html
Quick, Informative, and to the point! This was exactly what I need ! I was able to follow along and used the formula! CHEERS!
Absolutely brilliant and so easy to follow ! It worked every step of the way.. tx a mil
Such a huge help specially for the likes of me who are not excel efficient. Very easy to understand, follow and has lots of practical information.
This video came in clutch for a HUGE project for my wife! Thanks, mate!
Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations.
You are an excellent teacher! I teach over 500 students a week, and needed to view my students in another program in different ways. This clear tutorial saved me over 3 hours of work. Thank you so much!
Thank you so much! It seems pretty useful. You also use a very understandable language.
You truly taught me this and i wanted to learn this my whole career!!!
FANTASTIC - you save me hrs of work! Now, I also need to go the other way - to separate the street # from the st. name into 2 separate cells.
GREAT Tutorial! Easy, Simple and to the Point
By far the best and easiest tutorial by far.👍👍👍
Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations. Thank you soo much'
Very concise, thank you for saving me hours of work!
Thank you very much for this tutorial. It is a big help for me.
Excellent explanation.
Such a good tutorial, I'm trying to learn excel for my work and this is perfect.
Thanks for your help
Brilliant!
This is really useful.
Thank you.
Leng, it's been a pleasure helping you :)
Super easy to follow. it worked great!
AWESOME !!! Thanks, worked GREAT!!
Very informative,, thank you so much,, it makes my work easier.
Looking forward for more learnings about excel
You made things so easy! Thank you!
Thank you Paul this was very helpful
very easy to follow and informtive steps..
Thank you for the essential tricks.
Super! You are the best. So good explanation.
Genius, you should be my teacher. Fully smashing the like button here!! Thank you.
Ty dear, alot of problem solved❤❤❤
Thank you, simple but really helpful
Thank you this helped a lot
Wow thanks. I did it!!!!!!!! 🎉🥳🎉🥳🎉
It was so helpful,thank you so much for this tutorial. Loved it!
Thank God I found this super digestible video clip.. yey!
Many many thanks sir
good job.
thank you very helpful
thank you, it helped🙂
This was a very helpful video!
Great and right to the point!
Thank you!
Very helpful..thank you 😊
Thankyou so much... you're a hero
Thanks for this, but I cannot delete the individual cells or it will delete the new combined cell. I don't need the individual cells. Help please.
Thank you, very easy to follow
God Bless you.
Thanx very helpful
Thank you very much
Thank you so much sir, you solved my problem,
Loved this Thank You
Brilliant!! Thank you!!
Wonderful. Thanks! 😊
Thank you .
Thanku for saving my time
Great video but be advised, text needs to be formatted in "General" format or else the formula itself is displayed rather than the desire result.
Nice video. I prefer to use contatenation operator &
Thanks bro it is very easy to understand and very helpful Please
Glad it was helpful! Jidan, thank you for your feedback :)
Thank you so much man😊👍
Awesome! Thank you!
Thank buddy it's helpful
Krisha, it's been a pleasure helping you. Thank you for your feedback. :)
you are the best thank you so much i subed
Thank you
Thanks a lot
Thank you so much!!
You way is so typical I have a essay way
Thanks
Worked, but there is an issue, when i try search to find a name doesn't give me any result
What do you do if after doing this you need to delete the separate “First Name” and “Last Name” and just have the combined column
Hide
Copy the combined column and paste value in the same column then you can delete the first name Nad last name column. I hope this would help you
How about getting the first letter of the middle name. Example. Jose Mandito Rosales- Jose M. Rosales.
WOW,AMAZING
Thanks for the helpful video. There's an extra space on Lily Jones...must be a space after Lily in cell B4. Cheers
Great Sir
But I'm facing issue after entering formula in results showing formula itself
I just used this but when I went to delete old info it deleted info in cells. Is there a full video of how to safely save new spreadsheet
But now when I delete columns for first and last name it removes the entire thing? How do I get round that?
IS there a way to hide the separate first and last name cells? I just want the combined cells to show up on my excel sheet
How about the reverse? I have a column with the full name and trying to separate them.
how to copy concatenated data? like Tommy Smith in column "D" to some other excel sheet???
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!!
What if the person has 2 names before last name? example: Lopez, Anna Marie? Its hard to do concatenate
When I drag the formula down the column, it just copies the name in the first cell down to the other cells. How can I fix this?
Thank u
@0:50 to skip the intro
Brilliant
Kelly, it's been a pleasure helping you :)
thanks soft simple trick learned at age 26
How do you keep the merged names but delete the source cells?
Colleen, here is video tutorial: ua-cam.com/video/xO5AkIgjpxA/v-deo.html :)
helpful
Sagar, you’re welcome :) Thank you for your feedback :)
Does anyone know how to do this, but abbreviate the names?
But i need to copy the combined data to another table 😢
Advice to anyone. Listen to it in 2x speed. Helpful video but too slow. Thank you.
Saeeda, thank you for your feedback :)
@@ExcelTutorialsEasyClickAcademy Thank you for a very helpful video. 🙂
This does not help...But okay. I still have to re write every customer name to copy them.
What exactly did not work for you?
What if there are multiple spaces and comma ?
This was bullshit isn't working on 2007 excel
Please speak in hindi.
This is too much
Thank you!
Thank you so much
Thank you.
Awesome, thank you very much!
thank you
Thank you sir
Thanks