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 ► ruclips.net/video/J1ccouJGB5k/видео.html
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.
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.
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!
This video came in clutch for a HUGE project for my wife! Thanks, mate!
Absolutely brilliant and so easy to follow ! It worked every step of the way.. tx a mil
Thank you so much! It seems pretty useful. You also use a very understandable language.
Quick, Informative, and to the point! This was exactly what I need ! I was able to follow along and used the formula! CHEERS!
Thanks for your help
By far the best and easiest tutorial by far.👍👍👍
very easy to follow and informtive steps..
Thank you very much for this tutorial. It is a big help for me.
AWESOME !!! Thanks, worked GREAT!!
You truly taught me this and i wanted to learn this my whole career!!!
Many many thanks sir
Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations.
God Bless you.
Thank God I found this super digestible video clip.. yey!
Thank you!
Excellent explanation.
Thank you this helped a lot
Such a good tutorial, I'm trying to learn excel for my work and this is perfect.
Thank you very much
GREAT Tutorial! Easy, Simple and to the Point
Thank you for the essential tricks.
good job.
Thank you .
Thanx very helpful
Thank you Paul this was very helpful
Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations. Thank you soo much'
Wow thanks. I did it!!!!!!!! 🎉🥳🎉🥳🎉
thank you, it helped🙂
Brilliant!
This is really useful.
Thank you.
Leng, it's been a pleasure helping you :)
Thank you so much sir, you solved my problem,
Ty dear, alot of problem solved❤❤❤
Very concise, thank you for saving me hours of work!
Very informative,, thank you so much,, it makes my work easier.
Looking forward for more learnings about excel
Thankyou so much... you're a hero
thank you very helpful
Thanku for saving my time
Thanks a lot
Super! You are the best. So good explanation.
Thank you
Very helpful..thank you 😊
Loved this Thank You
Great and right to the point!
Genius, you should be my teacher. Fully smashing the like button here!! Thank you.
Wonderful. Thanks! 😊
You made things so easy! Thank you!
Super easy to follow. it worked great!
Awesome! Thank you!
Thanks
Thank you so much man😊👍
Thank buddy it's helpful
Krisha, it's been a pleasure helping you. Thank you for your feedback. :)
Brilliant!! Thank you!!
Thank you, simple but really helpful
Thanks bro it is very easy to understand and very helpful Please
Glad it was helpful! Jidan, thank you for your feedback :)
This was a very helpful video!
Thank you, very easy to follow
you are the best thank you so much i subed
Thank you so much!!
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.
Nice video. I prefer to use contatenation operator &
It was so helpful,thank you so much for this tutorial. Loved it!
thank u
WOW,AMAZING
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.
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
Thanks for the helpful video. There's an extra space on Lily Jones...must be a space after Lily in cell B4. Cheers
You way is so typical I have a essay way
How about getting the first letter of the middle name. Example. Jose Mandito Rosales- Jose M. Rosales.
Brilliant
Kelly, it's been a pleasure helping you :)
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
Great Sir
But I'm facing issue after entering formula in results showing formula itself
how to copy concatenated data? like Tommy Smith in column "D" to some other excel sheet???
helpful
Sagar, you’re welcome :) Thank you for your feedback :)
How about the reverse? I have a column with the full name and trying to separate them.
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
But now when I delete columns for first and last name it removes the entire thing? How do I get round that?
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?
Does anyone know how to do this, but abbreviate the names?
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: ruclips.net/video/xO5AkIgjpxA/видео.html :)
@0:50 to skip the intro
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.
Thank you so much
thank you
Awesome, thank you very much!
Thank you sir
Thanks
Thank u