/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 vote235 views1 answer
Vba excel do not recalculate before save
VBA
2 votes223 views1 answer
Date format for ms chart vb.net
VBA
0 vote243 views1 answer
Vba compare strings
VBA
0 vote196 views1 answer
How to sort datagridview in vb.net
VBA
1 vote229 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote231 views1 answer
Vbnet check if sting contians symbols
VBA
2 votes239 views1 answer
Excel vba check if string entirely alpha
VBA
2 votes223 views1 answer
Vba array contains
VBA
0 vote233 views1 answer
Vbnet click on dgv cells
VBA
0 vote243 views1 answer
Date as number vb
VBA