Splitting a column after a specific word

[dunlopoil]

Hi,
I have a column of text describing various products. The word 'type' is always included in the description, e.g. "electronic gizmo type 323". I want to split the column to isolate everything including and after the word 'type'. If possible, non-code please.

Thanks,
Doug.

 

[VoG]

Like this?

Excel Workbook
	A	B
1	electronic gizmo type 323	type 323
Sheet2

 

[dunlopoil]

Like this?

Excel Workbook
	A	B
1	electronic gizmo type 323	type 323
Sheet2

That's it, thanks VoG II!