Get last word in Excel - 2 Minute Excel Formula

preview_player
Показать описание
Learn how to extract the last word in a cell using excel formula

File Location:

Get ANY word from Excel using TEXTAFTER and TEXTBEFORE formula:

Other 2 Minute EXCEL formula Videos:

2 MINUTE EXCEL FORMULA YOUTUBE PLAYLIST:

The EXCEL - EXTRACT series playlist

Get Last word formula: =TRIM(RIGHT(SUBSTITUTE(B3," ",REPT(" ",50)),50))

This is a 2 minute Excel tutorial showing you how to use formula to get the last word from a cell

Get the last word
Get the right word
Last word after a space
Excel formulas and functions

#excelformulas
#getlastword
Рекомендации по теме
Комментарии
Автор

Brilliant solution! Thanks for sharing.

trin
Автор

:) Hi! Thanks very much for your precious help. And you explain it very well.

fernandaromao
Автор

Thanks a lot! Saved me a lot of time! :)

zmurfarna
Автор

You should never that formula. You should the TEXTAFTER or TEXTBEFORE functions.

noisearchitect