Hi
Not sure how to go about doing this. I want to time the text of subtitle so it displays the specific text at the right time.
I have column A which is the starting frame number. Column C is the Text and they are different lengths in each row.
Column A Column C
00003 This is the text column and in different lengths.
00055 This is the second subtitle text in the column and long
00225 This is the third subtitle text.
What I want to do is depending on the length of the text in column C, have excel insert another Row (lets say if text is longer that 15 characters) everything else in text gets shifted down to the next newly inserted row and if another 15 characters is passed then that gets inserted into another newly added row right below it and so on.
Now there is A:1 which has 00003 , A:2 and A:3 is going to be blank.
A:4 is 00055. I want A:2 and A:3 to be the number which evenly fits between 00003 and 00055. So the new inserted one would look like this:
Column A Column C
00003 This is the text
00021 column and in different
00038 lengths.
00055 This is the second subtitle....
I only want the text which gets inserted to the new row to be cut off during spaces and not in the middle of a word. In the example above I didn't count the 15 character length for text.
Hope this makes sense to someone out there and can help me. Any help appreciated. Thanks
Not sure how to go about doing this. I want to time the text of subtitle so it displays the specific text at the right time.
I have column A which is the starting frame number. Column C is the Text and they are different lengths in each row.
Column A Column C
00003 This is the text column and in different lengths.
00055 This is the second subtitle text in the column and long
00225 This is the third subtitle text.
What I want to do is depending on the length of the text in column C, have excel insert another Row (lets say if text is longer that 15 characters) everything else in text gets shifted down to the next newly inserted row and if another 15 characters is passed then that gets inserted into another newly added row right below it and so on.
Now there is A:1 which has 00003 , A:2 and A:3 is going to be blank.
A:4 is 00055. I want A:2 and A:3 to be the number which evenly fits between 00003 and 00055. So the new inserted one would look like this:
Column A Column C
00003 This is the text
00021 column and in different
00038 lengths.
00055 This is the second subtitle....
I only want the text which gets inserted to the new row to be cut off during spaces and not in the middle of a word. In the example above I didn't count the 15 character length for text.
Hope this makes sense to someone out there and can help me. Any help appreciated. Thanks