Question : extract word in a text in excel
Answered by : kwams-ahortor
Excel formular
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))), (N-1)*LEN(A1)+1, LEN(A1)))
'Replace A1 with the target columns
'Replace N with the word position
Source : https://exceljet.net/formula/extract-nth-word-from-text-string | Last Update : Tue, 21 Sep 21