Extract the nth word in a text string in Excel and Google Sheets

=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),(C5-1)*LEN(A2)+1,LEN(A2)))

A2 = data cell; C5 = nth word to extract

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Extract Nth word from a text string in Excel

How to extract nth word from a text string in Excel?
Extract Nth word from a text string in Excel

EXTRACT NTH WORD FROM A TEXT STRING — EXCEL FORMULA AND EXAMPLE

=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),(C5-1)*LEN(A2)+1,LEN(A2)))

Extract Nth word from a text string in Google Sheets

How to extract nth word from a text string in Google Sheets?

EXTRACT NTH WORD FROM A TEXT STRING — GOOGLE SHEETS FORMULA AND EXAMPLE

=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),(C5-1)*LEN(A2)+1,LEN(A2)))

Other useful extract formulas in Excel and Google Sheets explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions