/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 vote237 views1 answer
Excel R1C1 mode
VBA
0 vote257 views4 answers
Jwt token vb.net validation
VBA
0 vote244 views1 answer
Default host vbox address
VBA
0 vote240 views2 answers
Excel vba protect cells with formula
VBA
0 vote243 views1 answer
Make all controls in an area not visable vb
VBA
8 votes231 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote264 views1 answer
Vba foreach 2d array
VBA
0 vote256 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote226 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote241 views1 answer
Loop through lines in text file vb net
VBA