Extract word in a text in excel

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 vote260 views1 answer
How to extract a file from an ISO:
VBA
0 vote396 views1 answer
Vba array of integers
VBA
8 votes395 views1 answer
Excel vba make word from bytes
VBA
0 vote286 views1 answer
Vba is integer
VBA
5 votes320 views2 answers
Excel vba write to the windows registry
VBA
0 vote261 views1 answer
Find days in month vba
VBA
5 votes314 views1 answer
Xlvba double quotes in string literal
VBA
0 vote229 views1 answer
How to sort datagridview in vb.net
VBA
0 vote277 views1 answer
Excel vba StartUpPosition
VBA
0 vote273 views1 answer
Excel vba move down to next visible cell
VBA