/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

1 vote177 views1 answer
Highlight selected cell in excel vba
VBA
0 vote170 views1 answer
Excel vba select multiple shapes
VBA
0 vote257 views2 answers
VB
VBA
0 vote183 views1 answer
Search in richtextbox vb.net
VBA
0 vote202 views1 answer
Vba code to select image in sheet
VBA
3 votes173 views1 answer
Excel vba read registry key value
VBA
1 vote188 views1 answer
If inputbox cancel vba
VBA
0 vote170 views1 answer
Vba add shape oval
VBA
0 vote179 views1 answer
Enable macros on opening workbook vba
VBA
0 vote189 views1 answer
Excel vba ternary
VBA