Extract Last Name using TEXTAFTER function in Excel

Extract Last Name using the TEXTAFTER function in Excel.
🍐Join my online course on Excel Tables
www.udemy.com/course/tables-i...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/excel-resources/
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#excelshorts #exceltip #exceltrick

[@Lifeofmiddleclassguy]

Ctrl -E is also one shot cut bro try it

[@ramusambari1387]

Hey hey

[@nileshsalunke5105]

Wow, Thanks for incorporating the logic in your videos as well.

[@user-gh7un2lq4e]

you can just type the first one by hans and press Cntr E

[@momi3652]

You have a perfect voice for asmr

[@Smart-network]

Only use ctrl e (smart fill).

[@DROIDFARM]

Brilliant! Liked and subscribed sir! Many thanks from Texas, USA!

[@BlessedKomal]

Excellent! Thank you.

[@AbigailMaiso]

Thanks for sharing!

[@oluyomifadipe5634]

Just wow. Excel is the best

[@dpdystro2227]

Ohhh I needed this on every data base ever!

[@providencewilliams8064]

Thanks alot, so helpful

[@hasanalamoudi436]

Just put last name of first row . Then select the remaining empty cells . Then press ctrl + E
U can use same process if u put first name . Or 2nd name . Ctrl + E understands the relation between two cells

[@koyval22]

You are a legend for using Zidane and Henry’s names. Lol

[@JH-KU]

Very useful, thank you

[@ben-uy1ud]

Pls also explain logic behind using - 1

[@Saif_Ali_Khan_1301]

Indexing number

[@simonghost9794]

string manipulation

[@Alexander_jade]

The - is synthax that means invert the index and start from the end. So -1 = text after the last delimiter, -2 = second to last, etc.

[@WereWade]

Groovy!

[@abhishekrawat5215]

@@Alexander_jade thanks buddy

[@srikanthakella7632]

You can simply use flash fill

[@RA-kd3ne]

Thanks..last and first one is easy than mid

[@SanjitKarnik]

Can use Flash fill too..

[@bishttrue166]

Yes but flash works only after 2016 or may be 2013

[@sandeep9498]

Flash fill could be helpful here

[@Kikutuca]

Nice tip.

[@silvanusowolabi9910]

Pls I will like u to do a VBA code to change text Cloro backwards

[@bijaytanty8434]

Thanks 👍👍

[@GhurairShaikh]

You can also use right and lens function

[@sauravrana342]

Thank you

[@alonzosmith6189]

Thank you,

[@dogwalker666]

Nice!

[@JANI310275]

Very good

[@praneshkumarrathinasamy7740]

Super but what will be the result if we give -2 or -3 at last?

[@jewel8482]

-2 gives middle name and -3 first name

[@soonsuicidal]

@@jewel8482 cool thanks. But what if the surname has 2 words which is common in my country. Surnames would be Dela Cruz or De Guzman or Delos Reyes. Is this still doable in Textafter functiom?

[@gvnslingergaming3739]

@@soonsuicidal I think you have to manually type it.

[@azizahmedkhan669]

You can also do it with flash fill easily

[@j.1548]

amazing!

[@venkateshs6929]

You can use Right function also..

[@arnaudmanir]

Power query is another option... Transform, split columns, delimiter

[@huyvuongnguyendinh]

Useful

[@sambarajkanaveni7312]

helpful 👍

[@gutar2]

Good luck with this in Asia

[@dgr8oneme]

But you can do this with the readymade function called "text to columns"

[@chubbydawme]

But that would mean he can't keep the original column intact

[@srujanachavala]

There is another method called =RIGHT. That can also be used

[@MounirAharchi]

Zinedine Zidane and Thierry Henry are in the Squad 😂😂😂

[@prestonuniversitypakistan6577]

Simply write Nolan and press Ctrl+E in below cell and boom you are done.

[@onkarshinde4424]

Flash fill is quick

[@johnathankrausrig9237]

Microsoft has a great reference for that stuff because it where made before the current Generation of failures startet work there

[@soonsuicidal]

This is really cool thanks. But what if the surname has 2 words which is common in my country. We have surnames like Dela Cruz or De Guzman or Delos Reyes. Is this still doable in Textafter functiom?

[@KaranRaj-hw6yr]

How to convert same formula into a shape made text, for any kind of poster making

[@shadowgaming23g57]

But the text after is not showing in my excel how can i bring it and make a video on it if you can

[@shraddhasrivastava4838]

A B B B
Formula if we need to count all B which comes after A?

[@sachinpharswan]

Will it work in date and time to

[@pratikmishra51]

How to devide column A in different column with same entries

[@JAQ1988]

Instead use flash fill that’s quick

[@tulopadullo_n_5700]

And what about people with 2+ surnames?

[@ve9351]

CTRL+E :)

[@tdbsrocky]

Very good idea

[@ksatyasirisha2013]

Hai,ajai Garu,
Can u tell ,why to type -1,plz explain,why can't type 1, instead.

[@rkatyayani1133]

How to select only for alphabets from the surname.

[@ES-fg5ib]

I think RIGHT formula would work as well, correct?

[@ashishnanda2051]

Hi Ajay, which office version we can find this function. I am using office 365 but can not find text functions.

[@ashvinkumarparmar5728]

So far these functions are on Beta channel (insiders) only with partial coverage.

[@carlosmartinezreborned6403]

How can you extract just the middle name on only the names that have a middle name while ignoring the rest that only have a 1st and last name?

[@realnohat]

Me: what the... i've been using LEN inserted inside RIGHT functions for years to achieve this.... thanx for this!

[@lantisdylan]

Question what if they have a suffix in there last name?

[@Penfold8]

What does the " -1" signify? What if I wanted the middle name?

[@nxteen_]

Same question

[@DaNceAi34]

Enter last name and press flash fill or CTRL+E Don't Think big

[@asimali5820]

In which version of Excel does it work?

[@joyelgeorge2292]

Just use flashfill

[@ericpaul4575]

Works great until you find out the last name of the fist person is Edward Nolan.

[@emicadic]

And then how do you delete the last name from the first cell?

[@bulldogkarma]

Doesn't work on my version of Excel on Office professional 2019

[@Armaan-bi6ox]

How to get auto description by enter the description code if u know pls tell me

[@atulsubba2085]

What if we need middle name and first name

[@ahmedmohammedabdullahi4011]

Grt

[@chandrasekharsrinivas9887]

I don’t have this function in my excel and what version have to download

[@noemi7576]

Which version of MS Excel this formula works? I am using 2021, this formula is not available.

[@NitaFunnyVideo]

What version of Excel is this

[@peli71]

Now for “John van ‘t Schip” …

[@cswalker21]

Sigh, and then in the very first use case someone will have a last name with a space in it.😢

[@curious_bird]

For Google sheets?

[@pradeepkumar2055k]

Hi I have bill no and Date both are joint like bill no 104/22-22/date I want remove date how I can do

[@sufyanbello6096]

Which version of excel is this please?

[@bisu7777]

But your formula doesn’t remove the last name from the first cell after applying. Last name remains in the first cell

[@mayurkhedekar4441]

I don't have this option in my version

[@SERGIO-cr6uy]

Finally an Indian that REALLY works for Microsoft!

[@songslibrary714]

How you select the name?

[@salim3786]

Flash Fill will do this job.

[@jagadishmaturu4691]

Describe all the details in formula

[@paradisekishtwar5302]

HOW TO SEPARATE FATHERS NAME FROM A ,B,C SS/O C

[@abhinavyoutube]

Sachin Tendulkar

[@rajeshkhanna8709]

Middle name
Like
Rao kri kum giri
Ram rao Kri
Ans i
Kri kum
rao

[@fyhdhgg]

someone explain why -1?

[@srinivasaleti123]

How to get First name

[@masihasultana7769]

I am not able to get this function. Tried in many ways

[@rainbowofsoups8570]

What about when the surname is "van der merwe", yes, all three words.

[@mahaboobbasha2278]

Ctrl+e enough

[@myathsu9390]

I can't find TEXTAFTER function in my excel, please help

[@angeloparana1984]

What if last name has 2 words?

[@karuneshgaikwad9687]

Why -1?

[@nivramarvin]

How about if the name is Robert De Niro, De Niro is the last name.

[@krs218]

Anyone notice Sachin Tendulkar?

[@NitaFunnyVideo]

Not working on 2010 excel

[@IamRobertMTV]

What if last name is De La Cruz???

[@FintaxYesh]

Mine is 365
But i cant find this formula

[@PipocaQ]

Which works until you run across someone with a space in their last name.
Then you have Mr de la Fuente complaining that he shouldn't be addressed as Mr Fuente and Sacha Baron Cohen complaining that he should be mr Baron Cohen.
Names are complicated; extracting first and last names from a full name is error prone.

[@axrita]

Copy&paste is the best way 😂

[@JANI310275]

i am getting this #NAME not last name