/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 vote139 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote148 views1 answer
Vb test if reference is null
VBA
8 votes145 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote155 views2 answers
Vba remove line breaks
VBA
1 vote142 views1 answer
What does vbs stand for
VBA
0 vote152 views1 answer
Show unix time in vba
VBA
0 vote197 views2 answers
VB
VBA
0 vote158 views1 answer
Date as number vb
VBA
1 vote149 views1 answer
Excel vba first and last row and column in range
VBA
0 vote155 views1 answer
Supprimer la valeur de celule vba
VBA