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 vote342 views1 answer
Find control with name vb
VBA
0 vote330 views1 answer
Show unix time in vba
VBA
1 vote350 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote378 views1 answer
Filesystemobject vba reference
VBA
0 vote375 views1 answer
Application.ExecutablePath VB.NET
VBA
3 votes350 views2 answers
Vba active workbook path
VBA
0 vote318 views1 answer
Vba sheet visible
VBA
2 votes317 views2 answers
Constructor vb.net
VBA
0 vote339 views1 answer
Vba createparameter null
VBA
1 vote345 views1 answer
Vba format string as cash
VBA