/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 vote237 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote219 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote248 views1 answer
Method showalldata of object _worksheet failed vba
VBA
4 votes232 views2 answers
Vba create folder if not exist
VBA
31 votes490 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote226 views3 answers
Write to text file vb.net
VBA
0 vote255 views2 answers
Delete all controls from list of control vb.net
VBA
1 vote228 views1 answer
Excel date to unix timestamp
VBA
0 vote253 views1 answer
Vba code to select image in sheet
VBA
3 votes261 views2 answers
Vba date to string
VBA