How to convert these cells of text?

Hi There,

I'm looking to convert cells of text like this:

https://s28.postimg.org/p871paoel/screenshot_4542.png

Into readable format like:

https://s30.postimg.org/yvr9mfuox/screenshot_4543.png

I did that manually, but wondering if there are ways with excel with some magic to do this automatically.

So combining the text and removing the subtitle time from it.

I have uploaded the worksheet.

Cheers,
Chris