Reply
 
Thread Tools Display Modes
  #1   Report Post  
Rom915 Rom915 is offline
Junior Member
 
Posts: 0
Default Need Help To Cut Out Repetitive Work In Word

Hello everyone. I am new to this forum and hope I have put this message in the right place.

I do a lot of repetitive work formatting dialogue scripts that I usually receive as a Word document, and I then have to reformat and cut and paste into standardised Excel document that gives each person’s dialogue a separate cell.

There are two main things that I need to do to clean up the initial document:

1. Remove timecode information (hh:mm:ss;ff), I would usually have between 2 and 3,000 of these scattered throughout the document.
2. Join split sentences together so that I can place a complete sentence into one cell.

My current workflow consists of going line by line to first delete each timecode and then I deleted the spaces between words and commas and carriage return at full stops to block each sentence into a separate line. I then select the entire document and paste this into Excel.

I have tried the following in Word:

Find & Replace using * but this identifies all the numbers in the document and does not really work as there are other numbers that I need to keep.

I have used ^p to block the entire document into one chunk and then I go through it to create full sentences in blocks.

I then cut and paste this into Excel. Remove the timecode using Find & Replace ??:??:??;?? which works great but unfortunately does not work in Word. Then I remove all the empty lines (blanks) using edit/go to.

It is a very long-winded process, and I was wondering if there is anyone that could help me find a quicker way of doing all this. By the way, I working with the latest versions of Microsoft Office 365 on a mac.

Thanks, and looking forward to hearing back from someone.
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
repetitive long sentances, how do i store and reused them in word Peter Building Surveyor Microsoft Word Help 3 February 19th 13 05:26 AM
repetitive names. diego New Users 1 April 16th 10 10:01 AM
Simple but repetitive use of combobox Ammon Microsoft Word Help 0 February 8th 10 07:57 PM
repetitive word use ReadAllAboutIt Microsoft Word Help 2 August 20th 08 01:49 AM
Count repetitive words itgreenwich Microsoft Word Help 5 October 9th 07 07:41 PM


All times are GMT +1. The time now is 07:14 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"