
Channel: MrExcel.com
Category: Howto & Style
Tags: excelfind next to last word in excelusing textafter in excelmrexcelfind second to last word in excelfind penultimate word in excel14 new functions in excelusing textbefore in excelmicrosoft excelbill jelen
Description: Way back in episode 2326, I spent 8+ minutes showing how to use LET to get the second to last word from a cell. Today, it still requires TEXTBEFORE, TEXTAFTER, and TRIM but can be done in 45 seconds.



















