In this video tutorial, we’ll have a look at how to combine the contents of two cells – in this case a first name and a family (or last) name – thanks to which we’ll have a full name merged in one cell. Keep in mind that you’re not limited by the size of the table – you can work with lists much longer than this. It’ll save your time and you’ll avoid dull copying and pasting data bit by bit.
Are you wondering:
How to Separate Names in Excel
►
How to Merge Cells in Excel
►
================
–⏱️Timestamps⏱️—
0:00 How to Combine First and Last Name in Excel
1:12 How to Combine First and Last Name in Excel Using ‘CONCATENATE’ Function
3:22 How to Use ‘CONCATENATE’ Function in Other Rows
4:02 How to Change Concatenated Data
================
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! 🙂
►
Transcription How to Sort Alphabetically in Excel here
►
Got Microsoft Office 365? Get it here
►
Become a Patron:
Do you find our tutorials useful? Chip in to keep us going. You can make a one-off donation with PayPal or support us regularly on YouTube. Thank you!
PayPal ►
YouTube ►
Connect:
LinkedIn ►
Facebook ►
Screen Recorder & Video Editor:
Camtasia ►
Voice over artist ►
#ExcelQuickAndEasy #EasyClickAcademy
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
How to Separate Names in Excel ► https://www.youtube.com/watch?v=J1ccouJGB5k
thank you
Nice video. I prefer to use contatenation operator &
Thank you so much sir, you solved my problem,
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.
This is too much
Thank you
Great Sir
But I'm facing issue after entering formula in results showing formula itself
Thank you!
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!!
Does anyone know how to do this, but abbreviate the names?
Thank you, simple but really helpful
What if the person has 2 names before last name? example: Lopez, Anna Marie? Its hard to do concatenate
Super! You are the best. So good explanation.
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!
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.
This was bullshit isn't working on 2007 excel
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?
Thankyou so much… you're a hero
Thanks for the helpful video. There's an extra space on Lily Jones…must be a space after Lily in cell B4. Cheers
Thanks a lot
Thank you so much man😊👍
By far the best and easiest tutorial by far.👍👍👍
Awesome, thank you very much!
Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations. Thank you soo much'
Thank you 🙏
how to copy concatenated data? like Tommy Smith in column "D" to some other excel sheet???
Thank you so much!!
Thanku for saving my time
I ran into a more complex problem. I needed to switch the last name and first name (because they were listed as "Owens Bronson, Jenny Olivia" [Yes! that complex!]) and also take out the middle name… and on top of that I needed it to dynamically reference cells because those cells were linked to another document. And… on top of that, many of the last names were double last names. I ended up coming up with the formula (which is a combination of some formulae I found and some personal trial and error) and I thought it might help someone:
=IF(ISTEXT(TRIM(MID(SUBSTITUTE(E53," ",REPT(" ",LEN(E53))), FIND(",",SUBSTITUTE(E53," ",REPT(" ",LEN(E53))))+LEN(E53)+1, LEN(E53)))&" "&LEFT(E53,FIND(",",E53)-1)),TRIM(MID(SUBSTITUTE(E53," ",REPT(" ",LEN(E53))), FIND(",",SUBSTITUTE(E53," ",REPT(" ",LEN(E53))))+LEN(E53)+1, LEN(E53)))&" "&LEFT(E53,FIND(",",E53)-1),"")
Genius, you should be my teacher. Fully smashing the like button here!! Thank you.
Thank you, very easy to follow
Absolutely brilliant and so easy to follow ! It worked every step of the way.. tx a mil
Thank you sir
Super easy to follow. it worked great!
Great, but now when I try to copy and past the combined names into a new Sheet I get an error. Thoughts?
Thank you this helped a lot