Extract Last Name using TEXTAFTER function in Excel

A B B B

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

Why -1?

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

Thanks alot, so helpful

Flash fill is quick

Will it work in date and time to

How to select only for alphabets from the surname.

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

I don't have this option in my version

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

Not working on 2010 excel

What version of Excel is this

You can also use right and lens function

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

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

Middle name
Like

Rao kri kum giri

Ram rao Kri

Ans i

Kri kum
rao

What if we need middle name and first name

Thanks..last and first one is easy than mid

someone explain why -1?

How to devide column A in different column with same entries

You have a perfect voice for asmr

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

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

Which version of excel is this please?

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?

How to get First name

Just use flashfill

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

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

How you select the name?

Nice!

This formula is not showing in my excel, I install the MS Office LTSC Professional Plus 2021.. Please guide can we have another excel that can work these formulae without paid version of excel?

not works in ponce de leon :)

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

Sachin Tendulkar

this wouldn’t work well in Spain

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

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

Nice tip.

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

What if last name has 2 words?

For Google sheets?

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

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

Flash Fill will do this job.

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

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

Finally an Indian that REALLY works for Microsoft!

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

Ohhh I needed this on every data base ever!