/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 vote205 views1 answer
Rotate image by any angle vb.net
VBA
0 vote185 views1 answer
Vba dictionary length
VBA
1 vote195 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote250 views2 answers
Excel vba store array and write to sheet
VBA
0 vote195 views1 answer
Default host vbox address
VBA
8 votes208 views1 answer
Excel vba make integer
VBA
-1 vote201 views2 answers
Excel vba delete empty rows
VBA
0 vote214 views1 answer
Group controls programmatically vb
VBA
0 vote189 views1 answer
Excel vba range contains
VBA
0 vote205 views1 answer
Vb ternary
VBA