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

22 votes240 views1 answer
Xlvba check for folder
VBA
0 vote183 views1 answer
Excel run macro every 5 minutes
VBA
0 vote174 views1 answer
Vbnet add axis labels to chart
VBA
1 vote173 views1 answer
Vba optional
VBA
0 vote204 views4 answers
Vgrive,deb
VBA
0 vote167 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote205 views1 answer
Vba registry settings
VBA
0 vote174 views1 answer
Arq linux
VBA
0 vote172 views1 answer
Excel vba address not absolute
VBA
0 vote178 views1 answer
Nested if else in vb.net
VBA