View Single Post
 
Old 04-29-2020, 01:45 PM
Benali Benali is offline Windows 10 Office 2013
Novice
 
Join Date: Apr 2020
Posts: 10
Benali is on a distinguished road
Default Want Macro to join lines and delete numbers

Greetings,

I am not certain what to ask as my knowledge of macros is limited to excel. What i am trying to do is take a transcription form youtube video. Copy and paste to a word document and push a button to have it move all the lines together. Below is how the transcript looks. I want to eliminate the numbers that go from 00:00 to 99:99 and join the sentences together if its even possible. It is time consuming to delete , enter, space ect… as you can imagine. We appreciate your help in advance as i am sure there are some gurus on here.


00:04
and then this you probably were it was
00:07
been so hard for us United States
00:09
I think we've solved we've tried to get
00:15
a private decree in the United States
00:16
and then if I told you that I felt
00:18
fifteen people I probably not funny
00:20
every time I you know I helped a guy in
00:26
Florida this foreclosure he was studying
00:34
kept mailing it into the clerk should
00:36
keep returning it no notes we put a
00:40
money order everything we could think of
00:42
she returned the whole thing I like I'm
00:46
sorry what your state is doing it's just
Reply With Quote