Extract word in a text in excel

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: exceljet.net

Similar codes

1 vote217 views1 answer
Add rows to datagridview vb.net
VBA
0 vote244 views1 answer
Excel vba unlock sheet without password
VBA
0 vote238 views1 answer
Vba dictionary length
VBA
0 vote230 views1 answer
Excel R1C1 mode
VBA
0 vote220 views2 answers
Excel vba protect cells with formula
VBA
0 vote219 views1 answer
Vba array dimensions
VBA
0 vote207 views1 answer
Excel text to columns line break
VBA
3 votes225 views1 answer
Vba request json
VBA
0 vote238 views1 answer
Vba vbcrlf chr
VBA
0 vote222 views1 answer
Vba exit while
VBA