/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 vote158 views1 answer
Excel vba calculate
VBA
0 vote189 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote175 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote162 views2 answers
Vb.net include quotes in string
VBA
0 vote162 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote160 views1 answer
Not allow form to be resized
VBA
3 votes157 views1 answer
Vba make long from two shorts
VBA
5 votes171 views1 answer
Xlvba double quotes in string literal
VBA
0 vote153 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote157 views1 answer
Vba run command
VBA