How to Extract Last Name in Excel (3 Easy Ways) | No Formula Used

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.

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

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

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:

[sujithortan]

The best person to simplify tasks, it took me minutes to understand the wildcard character trick.

[Jobin.Thomas]

Find & Replace is a cool feature.. ❤️

[martawro]

so much useful content in just 7 minutes, so happy you shared, thank you 🙂 it is so helpful 🙏

[kumarsreenivas]

As always awesome presentation and of course brilliant tricks.

[wayneedmondson]

Great tips Sumit! Thanks for sharing. Thumbs up!!

[relax]

This is a game changer for me! Thank you!

[scouter-xnzi]

Once more a most helpful video. Thank you !
Any chance you might make one where we handle this task with VBA ?

[shiffamohammed]

Thank you so much Sumit, for another amazing excel tutorial video.

[MareeTeolanafo]

Another nice video, sorry you had the recording issues.

[michaellundsrensen]

The Best Excel course I ever have seen!
Can you tell me how I split First names and Last name, without using Power Query ?

[cowidster]

It can also be done by the Text to Column feature.

[kebincui]

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.

[waltervanvlasselaer]

Thank you for this excellent video.
I have still a problem on how to extract the "last name" from people that have a name like mine: "Walter Van Vlasselaer", where "Walter" is my Frist Name and "Van Vlasselaer" is my Last Name.
The same goes for names like "Jan De Lichte" (Jan + De Lichte), "Gilles Van den Borre" (Gilles + Van den Borre).
Any idea how to solve that ?

[TheRigs]

Its always a joy watching your videos. How can I get your free power query course?

[rakeshnaidi]

Dear sanjay Bansal please inventory office use

[srikantmukherjee]

Can we Replace any Text Before a Delimiter in Power Query?
Like I have below Excel
Zone - MP
Region - Veg
Nepal
State-Bhtan
Dubai

In ExcelSheet, Find and Replace, We do like * - and Replace All

What to be Used in Power Query to Replace any Text or Value Like *

Please Help

[arindambhattacharya]

please show how to extract the first name

Is there anyway to do this using a Formula?

[amrshaker]

Good day .. if you please help me to solve a problem I faced .. How to convert excel 2016 to excel 265 in vba



Because I faced a problem with libraries