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 vote239 views1 answer
.net dark title bar
VBA
0 vote227 views1 answer
Refresh token em vb net
VBA
0 vote244 views1 answer
Excel vba remove formatting from cell
VBA
5 votes250 views1 answer
Excel vba left word from Long Integer
VBA
0 vote266 views1 answer
Make your computer talk vbscript
VBA
3 votes224 views1 answer
Excel vba last row in range
VBA
0 vote238 views1 answer
Excel vba scroll to cell
VBA
0 vote248 views1 answer
Excel filter by date not working vba
VBA
0 vote261 views1 answer
Excel last used row
VBA
0 vote256 views1 answer
Excel vba send HTTP POST to server
VBA