For example, you have the following the text in a cell “A1”:

Can you help me extract the last word in this cell in Excel?

To extract the last word “Excel”, use one of the following formula:

`=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))`

or

`=MID(SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))),FIND("^",SUBSTITUTE(A1," ","^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,256)`

The result:

Excel

## 11 Comments

Very helpful ! Thanks a lot ! ðŸ™‚

You’re welcome Chetan!

Very helpful!!I was searching this.

I would like to know how to insert a blank space after the last word? Please kindly help me.

Hi Vishnu! That’s easy just add

`&" "`

to the end of your formula.It was very useful. Thanks a ton â˜º

You’re welcome, Mahesh!

Thank you for this info. It helped me heaps!

( So much easier than extracting each one individually )

Inexplicably the last word formula fails for data

`Joakina (Joakim?) Enoksen`

. In Excel 2010 on my English Windows 8.1 laptop in Norway.Hi Alf! I just tried it and it works. Using any of the two formulas above, I am able to extract “Enoksen” from the string “Joakina (Joakim?) Enoksen”. Can you add a link to the Excel file? I can try to de-bug it for you!

Karen–

You are AWESOME!

You are very welcome, Bilal! So happy I was able to help ðŸ™‚