You have a bunch of sentences in Excel.
How do you find the last word in each cell using a formula?
The new TEXTAFTER function solves the problem.
How do you find the last word in each cell using a formula?
The new TEXTAFTER function solves the problem.
Transcript of the video:
Find the last word in a cell. We want to get the last word from each sentence over there in column A.
So we are going to use the new TEXTAFTER.
=TEXTAFTER(. I want cell A2.
I want everything after a space. And which space? This is so cool rather than say it's the 5th or 6th or 7th space because we don't know how many words there are, say negative one, which will get us everything after the last space.
Ctrl+Enter and Done. I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
So we are going to use the new TEXTAFTER.
=TEXTAFTER(. I want cell A2.
I want everything after a space. And which space? This is so cool rather than say it's the 5th or 6th or 7th space because we don't know how many words there are, say negative one, which will get us everything after the last space.
Ctrl+Enter and Done. I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
