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 in Excel  

How to Merge Cells in Excel
►    • How to Merge Cells in Excel  

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

❤ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube ► https://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! :)
► https://www.youtube.com/c/ExcelTutori...

Transcription How to Sort Alphabetically in Excel here
► https://www.easyclickacademy.com/how...

Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy...

Connect:
LinkedIn ►   / easyclickacademy  
Facebook ►   / easyclickacademy  

Screen Recorder & Video Editor:
Camtasia ► https://techsmith.pxf.io/c/1266206/34...

Voice over artist ► https://seanantonyvo.com

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy