Audiobook – Le Chien des Baskerville Chapter 6

If you wish to have the French transcript of this video, this is how you accomplish the task. Play the video in YouTube, and beneath the screen there is “More”, with a selection for “Transcript”. Highlight, copy and then paste into Excel (text only).

To remove the time from the lines, place this formula in the B column, starting at the B1 cell, “=RIGHT(A1,LEN(A1)-4)”. Fill down until you get to over 10 minutes, where you change the formula to “=RIGHT(A#,LEN(A#)-5)”. The # is the starting row. Fill down. Then copy the lines from the B column, and paste them into a Word type document, using paste unformatted text. The transcript will still have some breaks and typos, but you’re 95% done.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s