/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 vote126 views1 answer
Loop through lines in text file vb net
VBA
0 vote140 views1 answer
Vba check if class implements interface
VBA
2 votes118 views2 answers
Constructor vb.net
VBA
0 vote121 views2 answers
Excel vba prevent save
VBA
0 vote131 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote138 views1 answer
Vbnet check if string is only numbers
VBA
0 vote123 views1 answer
Vba add shape oval
VBA
5 votes159 views1 answer
Excel vba get user selected range
VBA
0 vote127 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote118 views1 answer
Vbnet add new ecel sheet
VBA