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

0 vote267 views1 answer
Excel vba scroll to cell
VBA
0 vote244 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote248 views1 answer
Vba random number
VBA
0 vote246 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote186 views1 answer
Vba set vs dim
VBA
3 votes302 views1 answer
Excel vba make long from two shorts
VBA
8 votes376 views1 answer
Excel vba make a short integer from two bytes
VBA
1 vote233 views1 answer
Excel vba autofit
VBA
0 vote213 views1 answer
Excel vba show developer tab
VBA
0 vote235 views1 answer
Excel vba formatconditions positive
VBA