HDTutorial
EN

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Combine First and Last Name in Excel

582,877 views October 26, 2019 4:42

Watch on YouTube
ChannelExcel Tutorials by EasyClick Academy

Chapters

Description from the creator

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

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

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

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

Transcription How to Sort Alphabetically in Excel here
► easyclickacademy.com/how-to-combine-first-and-l…

Got Microsoft Office 365? Get it here
► easyclickacademy.com/buy-microsoft-office/?utm_…

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

Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/347799/5161?u=https%…

Voice over artist ► seanantonyvo.com

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

About this tutorial

Excel Tutorials by EasyClick Academy published this 4:42 video tutorial on October 26, 2019. It has been watched 582,877 times on YouTube.

Duration
4:42
Published
October 26, 2019
Views
582,877
Likes
4,179

Tags

Share

This tutorial in other languages