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

5 votes301 views1 answer
Vba array worksheet.index
VBA
1 vote315 views1 answer
Add rows to datagridview vb.net
VBA
13 votes449 views2 answers
Vba write text file
VBA
0 vote299 views1 answer
Vbnet add new ecel sheet
VBA
0 vote309 views1 answer
Vbscript check if string contains
VBA
0 vote325 views1 answer
Vba collection contains
VBA
5 votes359 views1 answer
Excel vba get user selected range
VBA
0 vote325 views1 answer
Vba round to 2 decimals
VBA
1 vote334 views1 answer
How to remove zeros in excel
VBA
0 vote320 views1 answer
Vba timestamp -- milliseconds
VBA