Move or Exctract data value after specific word

[jellevansoelen]

Hi,

I have a excel file with a lot of this cells:

Book2
	A
1	renewal store by G. de Vries
2	build house by R.J.D. van Kampen
3	draw made trough G. Jonkers
4	renewal barn by S.D.S. Groot
Sheet1

Is there any way to move the data starting with the words by and made trough to another cell.

Like:

Book2
	A	B
1	renewal store	by G. de Vries
2	build house	by R.J.D. van Kampen
3	draw	made trough G. Jonkers
4	renewal barn	by S.D.S. Groot
Sheet1

And if is possible to remove the words by and made trough, like:

Book2
	A	B
1	renewal store	G. de Vries
2	build house	R.J.D. van Kampen
3	draw	G. Jonkers
4	renewal barn	S.D.S. Groot
Sheet1

But else I can't find and replace this words.

Tnx a lot.

 

[Joe4]

One easy way would be to do a Find/Replace on "by" and "made through", replacing them with something like a pipe symbol ("|").
Then, do a Text to Columns, choosing the delimited option, using the pipe symbol as the delimiter.