/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 vote192 views2 answers
Excel vba copy paste after last row
VBA
0 vote206 views1 answer
How to format a textbox as date vb net
VBA
0 vote190 views1 answer
Excel vba disable alerts
VBA
0 vote197 views1 answer
Excel vba center userform
VBA
0 vote294 views1 answer
Find the name of the last excel sheet vb
VBA
8 votes474 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote198 views1 answer
Enter into cells data grid view
VBA
1 vote230 views1 answer
Vba format string as cash
VBA
0 vote201 views3 answers
Write to text file vb.net
VBA
3 votes209 views1 answer
Vba make long from two words
VBA