/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 vote242 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote202 views1 answer
Quit excel with save changes dialog vb.net
VBA
0 vote222 views1 answer
VBA Sort RossetaCode
VBA
0 vote220 views1 answer
Backspace key has stopped working visual studio
VBA
1 vote240 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote202 views1 answer
Vba apostrophe chr
VBA
0 vote237 views1 answer
Remove last 8 characters from string vb
VBA
12 votes273 views1 answer
Excel vba write string to text file
VBA
0 vote309 views1 answer
Vba change active sheet
VBA
0 vote236 views4 answers
How to continue formula in below line in vba code
VBA