/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 vote244 views1 answer
How to get value from clipboard in vbnet
VBA
2 votes241 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote242 views1 answer
Set column width of datagridview vb.net
VBA
0 vote227 views1 answer
Get current year vb
VBA
0 vote239 views1 answer
Create links in msgbox in vb
VBA
-1 vote265 views1 answer
Text to speech vb.net
VBA
0 vote267 views1 answer
How to add line graph vb net
VBA
0 vote267 views1 answer
Vbscript Trim
VBA
0 vote255 views1 answer
Windows Forms dark title bar
VBA
0 vote249 views1 answer
Putting marquee in vb.net
VBA