Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-02-2017, 09:15 PM
pirwin pirwin is offline Windows 10 Office 2013
Novice
 
Join Date: Aug 2017
Posts: 2
pirwin is on a distinguished road
Default How to make word autofill characters in a column

Not quite sure how to word this.



I prepare scripts for dubbing animation. There is a column beside the lines the actor reads where I enter the "timecode" of where the line begins. This corresponds to the video in the foreign language.

A typical timecode for example is 10:00:02:21 (hr:min:sec:frame)

I'm sick of entering colons beside every number, is there a way I can format the cells so that they would autofill the colons : between the numbers? So I could just hammer away on the numpad and not have to worry about them? Every code would be in that same format.

Sorry if this is a roundabout way to try and ask for something like this, I'm sure there's an easier way of expressing it.

Thanks!
Reply With Quote
  #2  
Old 08-02-2017, 09:38 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,326
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Word has no built-in method for formatting cells as times, currency, etc. Moreover, even in Excel - which can do that - you'd still have to type the colons, but what you're typing isn't even a recognized time format.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 08-03-2017, 08:18 AM
Ulodesk Ulodesk is offline Windows 7 64bit Office 2013
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 728
Ulodesk is on a distinguished road
Default

Pirwin, I sympathize. I have the same issue. It occurs to me that you could create a form, in which each number pair would be typed in a field, with colons in between the fields. In a form, properly set up, after typing in a field, a tab sends you to the next.
Also, though I'm not sure if Word fields can do this, you are surely familiar with web forms that automatically advance your cursor to the next field once the requisite number has been entered in the previous. The only issue in this case, would be whether you need to type other text, e.g., actors' lines, after one time code, prior to entering the next TC.
Once the field:field:field:field is created in one cell, it can be quickly copied to the others in the column. You can look up forms; you have to protect the form before you can type in the fields.
__________________
Sine scientia ars nihil est
Reply With Quote
  #4  
Old 08-03-2017, 08:29 AM
Ulodesk Ulodesk is offline Windows 7 64bit Office 2013
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 728
Ulodesk is on a distinguished road
Default Time Code form

Here's an example, attached. I used Word's legacy textform, which is more compact than content controls. Enter in one field, tab to get to next. Only the forms are available for typing in this case.
Attached Files
File Type: docx Code Form.docx (13.1 KB, 3 views)
__________________
Sine scientia ars nihil est
Reply With Quote
  #5  
Old 08-03-2017, 06:26 PM
pirwin pirwin is offline Windows 10 Office 2013
Novice
 
Join Date: Aug 2017
Posts: 2
pirwin is on a distinguished road
Default

Ah thanks guys!

I knew it was a little far fetched! I guess there really isn't any way to do it in word. It would probably take a whole lot of trouble to find or make a program that achieved the function.

And thanks Ulodesk! Thats definitely the closest I could get to what I want, but it doesn't really save you a key punch, and I'm sure I'd run into formatting trouble.
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating AutoFill form - AutoFill information depending on a selection. RyanHarper Word 3 06-15-2015 01:01 PM
Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Junk characters (box-like characters) in Word file Sashikala Word 1 04-20-2010 02:03 PM


All times are GMT -7. The time now is 10:09 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft