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 vote159 views2 answers
Excel vba close without saving
VBA
0 vote170 views1 answer
Excel run macro every 5 minutes
VBA
0 vote190 views1 answer
Excel vba move down to next visible cell
VBA
0 vote168 views1 answer
Selecttoken em vbnet e json
VBA
0 vote160 views1 answer
Add Formula to Shape Text in VBA
VBA
2 votes149 views2 answers
Constructor vb.net
VBA
1 vote157 views1 answer
If inputbox cancel vba
VBA
0 vote171 views1 answer
Vba format currency
VBA
0 vote190 views1 answer
Excel vba round to whole number
VBA
0 vote168 views2 answers
Vb.net include quotes in string
VBA