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 vote244 views1 answer
Vba table header name
VBA
1 vote232 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
2 votes237 views1 answer
Excel vba extract file name
VBA
0 vote235 views1 answer
Excel vba prevent saving workbook
VBA
4 votes227 views2 answers
Excel vba last column with data
VBA
0 vote268 views1 answer
Excel vba protect sheet
VBA
0 vote226 views1 answer
Create links in msgbox in vb
VBA
0 vote276 views2 answers
Excel vba store array and write to sheet
VBA
0 vote215 views1 answer
Type excel.application is not defined vb
VBA
0 vote235 views1 answer
Excel vba open browser
VBA