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

2 votes297 views2 answers
Constructor vb.net
VBA
0 vote326 views1 answer
Test if form is open vb
VBA
0 vote303 views1 answer
Compare dates vb
VBA
1 vote318 views1 answer
Excel vba last column in range
VBA
0 vote289 views1 answer
Vba copy paste value only
VBA
0 vote315 views1 answer
Excel vba cell on change
VBA
0 vote295 views1 answer
Vba get text file content
VBA
0 vote394 views1 answer
Wpf dark title bar
VBA
0 vote325 views1 answer
Excel vba disable screen update
VBA
0 vote296 views1 answer
Vba declare 64-bit ptrsafe
VBA