/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 vote341 views1 answer
.net dark title bar
VBA
0 vote312 views1 answer
Excel vba hide columns
VBA
0 vote362 views1 answer
Find if year is leap year vb
VBA
1 vote285 views1 answer
Vba Remove Case Sensitivity
VBA
3 votes363 views1 answer
Excel vba make long from two shorts
VBA
0 vote340 views1 answer
Vba shape transparent
VBA
2 votes317 views1 answer
Date format for ms chart vb.net
VBA
0 vote333 views1 answer
Vba type variable
VBA
1 vote298 views1 answer
Ms access open form to new record
VBA
0 vote355 views2 answers
VB
VBA