/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 vote219 views1 answer
Excel vba current folder
VBA
2 votes236 views1 answer
Vba file from path
VBA
15 votes453 views1 answer
Excel vba wait
VBA
0 vote251 views1 answer
How to add line graph vb net
VBA
-1 vote218 views1 answer
Vba code to add new column in table
VBA
0 vote228 views1 answer
Loop through all text boxes in a form vb
VBA
5 votes248 views2 answers
Excel vba write to the windows registry
VBA
0 vote251 views1 answer
Group controls programmatically vb
VBA
2 votes217 views1 answer
Excel vba date to string conversion
VBA
0 vote293 views1 answer
Application.ExecutablePath VB.NET
VBA