/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 vote187 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote196 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote178 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote184 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote220 views1 answer
Excel vba convert cells address
VBA
0 vote204 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote268 views1 answer
Vba change active sheet
VBA
0 vote198 views1 answer
Vba remove numbers from string
VBA
8 votes191 views1 answer
Run command pormpt in background windows
VBA
0 vote189 views1 answer
Vba find last column in a row with data
VBA