Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] bigstarman5d@gmail.com is offline
external usenet poster
 
Posts: 2
Default How to split text in Word, similar to Excel's text to columns ?

I'm using Word 2010. I am copying the transcripts from some Youtube videos (click on "More" below the video and choose Transcript (if available); then highlight and copy). However when I paste the transcript into Word, there is no delimiter between the time and the text. The transcripts look like this in Word:

0:00hello and welcome to this video tutorial
0:09brought to you by xxxxx today
0:13I'm going to show you how to
....
10:00so using the same principles as before
....

I found that I can paste the transcript into Excel and use the Data | Text to Columns feature to split the time by using the fixed width option. I just have to do two splits--one with a 3 digit time 0:00 and one with a 4 digit time 00:00 for 10 minutes and later. Then copy and paste to Word.

I was wondering if there is a way to perform this split within Word so that it looks like this:

0:00 hello and welcome to this video tutorial
0:09 brought to you by xxxxx today
0:13 I'm going to show you how to
....
10:00 so using the same principles as before


THANKS!!
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] bigstarman5d@gmail.com is offline
external usenet poster
 
Posts: 2
Default How to split text in Word, similar to Excel's text to columns ?

Paul Edstein gave me a solution that worked for me.

You could do this with an ordinary Find/Replace, whe
Find = :^#^#
Replace = ^&^32

Cheers
Paul Edstein
[MS MVP - Word]
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
Select Text with Similar Formatting is not enabled Trudy Microsoft Word Help 2 March 18th 10 04:02 PM
Select Text with Similar Formatting is not enabled Trudy Microsoft Word Help 0 March 18th 10 03:47 PM
Excel date columns as text in Merges Candida Microsoft Word Help 1 August 17th 07 08:21 AM
Intelligent search of Text in Word Docs similar to Acrobat Find fu Jim D. Microsoft Word Help 2 March 3rd 07 12:02 AM
How do I adjust the pasted text to Word from Notepad or similar p. Pan0912 Microsoft Word Help 1 January 21st 05 10:29 PM


All times are GMT +1. The time now is 02:44 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"