Extract the Nth Word From a Sentence in Excel
In Microsoft 365, split the sentence at spaces and pick the word you want: =INDEX(TEXTSPLIT(TRIM(A1)," "),3) returns the third word. In older versions, a SUBSTITUTE and MID formula does the same. Excel 365INDEX + TEXTSPLIT Any versionTRIM + MID + SUBSTITUTE Last wordTEXTAFTER(A1," ",-1) Excel 365 =INDEX(TEXTSPLIT(TRIM(A1)," "),3)Copy For The quick brown fox jumps, this … Read more