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
► https://www.youtube.com/watch?v=J1ccouJGB5k

How to Merge Cells in Excel
► https://www.youtube.com/watch?v=hRlrj_np0Tw

================

️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube ► https://www.youtube.com/@ExcelTutorialsEasyClickAcademy/join

================

⏱️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! :)
► https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1

Transcription How to Sort Alphabetically in Excel here
► https://www.easyclickacademy.com/how-to-combine-first-and-last-name-in-excel/?utm_campaign=How%20to%20Combine%20First%20and%20Last%20Name%20in%20Excel&utm_medium=YouTube&utm_source=Popis

Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy-microsoft-office/?utm_campaign=How%20to%20Combine%20First%20and%20Last%20Name%20in%20Excel&utm_medium=YouTube&utm_source=Popis

Connect:
LinkedIn ► https://www.linkedin.com/company/easyclickacademy
Facebook ► https://www.facebook.com/EasyClickAcademy

Screen Recorder & Video Editor:
Camtasia ► https://techsmith.pxf.io/c/1266206/347799/5161?u=https%3A%2F%2Fwww.techsmith.com%2Fvideo-editor.html

Voice over artist ► https://seanantonyvo.com

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy