/VBA/Extract the nth word from a text string

Extract the nth word from a text string

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 vote294 views1 answer
Excel vba disable keyboard input
VBA
0 vote307 views1 answer
Group controls programmatically vb
VBA
0 vote282 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote307 views1 answer
Vba is integer
VBA
15 votes390 views1 answer
Excel vba wait
VBA
5 votes329 views1 answer
Excel vba low word from Long Integer
VBA
1 vote322 views1 answer
Vba login website
VBA
0 vote319 views1 answer
Tester si une case est vide vba
VBA
2 votes296 views2 answers
Excel vba copy values range to another range
VBA
0 vote282 views1 answer
Vbnet get file name from path
VBA