In this video, I will show you three simple ways to extract the last name from full names in Excel. None of the methods use a formula and these are really fast.
✅ Free Power Query Course –
00:00 Intro
00:15 Extract Last Name Using Find and Replace
01:35 Extract Last Name Using Flash Fill
03:08 Extract Last Name Using Power Query
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
✅ Free VBA course – https://bit.ly/excel-vba-course
✅ Free Power Query Course – https://bit.ly/power-query-course
As always awesome presentation and of course brilliant tricks.
Really useful thanks brother
Thanks for sharing. For the Power Query, you can use a simple one step approach to get the last name. In power query editor, you can use Transform – Extract – extract- Text after delimiter (using advanced setting 'From the end of the input'). This way you do not have extra column of the first names and then delete it.
Once more a most helpful video. Thank you !
Any chance you might make one where we handle this task with VBA ?
Its always a joy watching your videos. How can I get your free power query course?
Sir, Thank you
Find & Replace is a cool feature.. ❤️
So Power Query is really a thing to begin .
Thank you Sumit. Excellent tutorial.
Dear sanjay Bansal please inventory office use