Extract the Last Word in Excel (Easy & Old-School Ways)

Visit my site to check out some of my hobby projects: https://www.lazydatadev.com

In today’s video, we explore how to:
* use TEXTAFTER to extract the last word in a text in an Excel cell
* nest multiple functions such as SUBSTITUTE, LEN, RIGHT, SEARCH to achieve the same result in older Excel versions
* using the FORMULATEXT function to see better the long and "ugly" formula

If you have questions or ideas for future videos, just leave a comment below.
And if this was useful, please like the video and consider subscribing for more Excel, VBA and Python data automation and analytics tutorials.

Видео Extract the Last Word in Excel (Easy & Old-School Ways) канала LazyDataDev