Selecting cells with a certain word and creating a new column

Hi,

I have lots of rows of data +25,000.

I would like to select cells that contain the word "Video" (could be "videoconference", "Catch_Up_Video_Conf", "video conference" etc) and place them in a new worksheet column. The cells also contain the date, time and sometimes more information.

I want a column similar to the results of the "Find & Replace" when I type in "Video" and press "Find All".

I have added an example that includes 200 rows and 3 cells that have within them the word "video".

If you could add a small explanation that would be great.

Cheers,

Dan

Nice one.

That was much easier than I expected!

Thank you for your help