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

1 vote208 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote226 views4 answers
How to continue formula in below line in vba code
VBA
0 vote157 views1 answer
Vba code to remove leading and trailing spaces
VBA
3 votes237 views1 answer
Excel vba make long from two shorts
VBA
0 vote220 views1 answer
Excel vba prevent saving workbook
VBA
0 vote256 views1 answer
How to call gcd in vba
VBA
0 vote203 views1 answer
Vba shape transparent
VBA
0 vote241 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote227 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
5 votes214 views1 answer
Excel vba low byte from INTEGER
VBA