Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query)
In this video, I will show you how to combine the first name and the last name in Excel using different techniques.
00:00 Introduction
00:10 Combine First and Last Name using CONCAT and Ampersand
01:38 Combine First and Last Name using TEXTJOIN
02:39 Combine First and Last Name using Flash Fill
04:32 Combine First and Last Name using Power Query
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial
Watch video Combine First and Last Name in Excel (Using Formulas, Flash Fill, Power Query) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 03 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 29,082 once and liked it 357 people.