How to Combine First and Last Name in Excel

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 Separate Names ...
How to Merge Cells in Excel
► • How to Merge Cells in ...
================
❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
TH-cam ► www.youtube.com/@ExcelTutoria...
================
⏱️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! :)
► th-cam.com/users/ExcelTutori...
Transcription How to Sort Alphabetically in Excel here
► www.easyclickacademy.com/how-...
Got Microsoft Office 365? Get it here
► www.easyclickacademy.com/buy-...
Connect:
LinkedIn ► / easyclickacademy
Facebook ► / easyclickacademy
Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/34...
Voice over artist ► seanantonyvo.com
#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[@ExcelTutorialsEasyClickAcademy]

How to Separate Names in Excel ► th-cam.com/video/J1ccouJGB5k/w-d-xo.html

[@johnmichaelkimdeborja773]

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.

[@aalsaadi3673]

Absolutely brilliant and so easy to follow ! It worked every step of the way.. tx a mil

[@Jamshley]

Quick, Informative, and to the point! This was exactly what I need ! I was able to follow along and used the formula! CHEERS!

[@Mimicomom]

Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations.

[@andrearoux3920]

GREAT Tutorial! Easy, Simple and to the Point

[@andreajoseph9208]

Super easy to follow. it worked great!

[@andreag3532]

By far the best and easiest tutorial by far.👍👍👍

[@christaylor7465]

AWESOME !!! Thanks, worked GREAT!!

[@suddenlyfoster]

This video came in clutch for a HUGE project for my wife! Thanks, mate!

[@masift1494]

Such a good tutorial, I'm trying to learn excel for my work and this is perfect.

[@shannenreyes3792]

You truly taught me this and i wanted to learn this my whole career!!!

[@mydurhamhouse7776]

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.

[@cinthiam.6495]

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!

[@Stephanie.0192]

Very concise, thank you for saving me hours of work!

[@FhabyyanRizza]

Thank you, simple but really helpful

[@battledrill]

You made things so easy! Thank you!

[@ricardosuarez8023]

Brilliant!
This is really useful.
Thank you.

[@ExcelTutorialsEasyClickAcademy]

Leng, it's been a pleasure helping you :)

[@infernusreyiz7040]

Thank you so much! It seems pretty useful. You also use a very understandable language.

[@Lufc-Chaddy]

Thank you, very easy to follow

[@lancesaludo6241]

It was so helpful,thank you so much for this tutorial. Loved it!

[@oicrajagiriya1319]

Thanks. This was very useful and you just saved me so much time. Very clear instructions and illustrations. Thank you soo much'

[@rjminton534]

Thank you this helped a lot

[@zennyario9571]

Very informative,, thank you so much,, it makes my work easier.
Looking forward for more learnings about excel

[@josemacadaeg7580]

Thank you very much for this tutorial. It is a big help for me.

[@thaiskitahara4144]

Awesome, thank you very much!

[@nadirhasan5234]

Thank you for the essential tricks.

[@GentlemanNietzsche]

Thank you Paul this was very helpful

[@joemarquard7558]

This was a very helpful video!

[@Peggygoldenadolph]

Great and right to the point!

[@Putravid]

Thankyou so much... you're a hero

[@camispurlock7640]

Brilliant!! Thank you!!

[@missdiNabyahera]

Thank God I found this super digestible video clip.. yey!

[@bumblevee123]

Wonderful. Thanks! 😊

[@abbytv9681]

thank you very helpful

[@robynbrown5712]

Loved this Thank You

[@rheaaguirre2598]

very easy to follow and informtive steps..

[@tatyanakorzhenko898]

Super! You are the best. So good explanation.

[@atulpahurkar9153]

Thanks for your help

[@bijayanandamishra9306]

Ty dear, alot of problem solved❤❤❤

[@carmelacalimlim7519]

Thank you so much!!

[@user-le2po4ks8t]

good job.

[@prasenjitnag7043]

Thank you so much sir, you solved my problem,

[@einel18]

Very helpful..thank you 😊

[@devikathampi977]

Thanku for saving my time

[@Shoaibrazallc]

Thank you so much man😊👍

[@krishahouse4972]

Thank buddy it's helpful

[@ExcelTutorialsEasyClickAcademy]

Krisha, it's been a pleasure helping you. Thank you for your feedback. :)

[@kangaroomokhtar659]

you are the best thank you so much i subed

[@chandurante5166]

Thank you!

[@Ladyhadassah]

thank you, it helped🙂

[@jaysatya4341]

Many many thanks sir

[@techgrace7]

WOW,AMAZING

[@educationladder7367]

Thanks a lot

[@mulavangue]

Thank you very much

[@George16437]

Genius, you should be my teacher. Fully smashing the like button here!! Thank you.

[@ashikurrahmanashik2305]

Thank you so much

[@palawenavibe1951]

Wow thanks. I did it!!!!!!!! 🎉🥳🎉🥳🎉

[@archanakhelurkar5364]

Thanx very helpful

[@Aveejai]

Thank you 😊

[@ExcelTutorialsEasyClickAcademy]

Jhonavee pleasure to help you :)

[@rechelbusmeon5352]

Thank you.

[@muntazirkhan4951]

Thank you sir

[@EdgenStyle]

God Bless you.

[@jidanmahmud142]

Thanks bro it is very easy to understand and very helpful Please

[@ExcelTutorialsEasyClickAcademy]

Glad it was helpful! Jidan, thank you for your feedback :)

[@leandersumampong2564]

Thank you

[@Samsunggalaxy-rl9go]

thank you

[@maestroandoy481]

Nice video. I prefer to use contatenation operator &

[@neiljohntolentino6365]

Thanks

[@abdirisakshafi4453]

Thank u

[@dhachutamilinfo]

thank u

[@deepreet511]

You way is so typical I have a essay way

[@karenmitchell3173]

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.

[@robertrumfelt7843]

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.

[@hasnainsaeed1]

how to copy concatenated data? like Tommy Smith in column "D" to some other excel sheet???

[@kellyknights1783]

Brilliant

[@ExcelTutorialsEasyClickAcademy]

Kelly, it's been a pleasure helping you :)

[@neiljohntolentino6365]

How about getting the first letter of the middle name. Example. Jose Mandito Rosales- Jose M. Rosales.

[@alexis2969]

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

[@parenthesis_in]

helpful

[@ExcelTutorialsEasyClickAcademy]

Sagar, you’re welcome :) Thank you for your feedback :)

[@kyliekramer76]

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

[@luvuzindagi2024]

Hide

[@merryk1818]

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

[@Balsero-qb9gv]

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

[@Carino9999]

How about the reverse? I have a column with the full name and trying to separate them.

[@timroesch7992]

Thanks for the helpful video. There's an extra space on Lily Jones...must be a space after Lily in cell B4. Cheers

[@shubhamgulhane3806]

Great Sir
But I'm facing issue after entering formula in results showing formula itself

[@sineadtohill2982]

But now when I delete columns for first and last name it removes the entire thing? How do I get round that?

[@magin10011]

Does anyone know how to do this, but abbreviate the names?

[@suffyanoffice]

thanks soft simple trick learned at age 26

[@colleenoltmannorfanello1360]

How do you keep the merged names but delete the source cells?

[@ExcelTutorialsEasyClickAcademy]

Colleen, here is video tutorial: th-cam.com/video/xO5AkIgjpxA/w-d-xo.html :)

[@vielgandecila7709]

What if the person has 2 names before last name? example: Lopez, Anna Marie? Its hard to do concatenate

[@purpleyellowlove]

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?

[@sparklestarasmr]

But i need to copy the combined data to another table 😢

[@purplebeard806]

@0:50 to skip the intro

[@saeedanasir]

Advice to anyone. Listen to it in 2x speed. Helpful video but too slow. Thank you.

[@ExcelTutorialsEasyClickAcademy]

Saeeda, thank you for your feedback :)

[@saeedanasir]

@@ExcelTutorialsEasyClickAcademy Thank you for a very helpful video. 🙂

[@VegaSpydr]

This does not help...But okay. I still have to re write every customer name to copy them.

[@ExcelTutorialsEasyClickAcademy]

What exactly did not work for you?

[@suprithapasapula964]

What if there are multiple spaces and comma ?

[@hemalchowdhury9]

This was bullshit isn't working on 2007 excel

[@user-si9hq3rb9q]

Thanks but your video isn't clear

[@Abhinavkumar-og3xd]

Please speak in hindi.

[@Mona-ml8lj]

This is too much

[@flair_showers]

Awesome! Thank you!

[@saniikakatamari]

Thank you!

[@issaiasbereket2907]

Thank you .

[@subcribe9971]

thank you