Extract Nth Word From A String

less than 1 minute read If you need to get the nth word in a text string (i.e. a sentence, phrase, or paragraph) you can so with a clever (and intimidating) formula that combines 5 Excel functions: TRIM, MID, SUBSTITUTE, REPT, and LEN. Download the example workbook here: Extract Nth Word from a String.xlsx ‘ … Read more