#1
|
|||
|
|||
Convert text to footnotes based on reference number
Good afternoon,
I'm hoping someone can assist, or at least point me to the best resource to figure this out myself. I'm working on a manuscript, which unfortunately has all the footnote references just as plain text (all 500 of them). All the footnotes are at the end of the manuscript, and just to make things harder, the numbering restarts for each chapter. So far, I have managed to utilise wildcard searches and SEQ Mylist to renumber the references sequentially. Their format is as: (1) (2) etc. I used: Wildcard search: ([\(])([0-9]{1,2})([\)]) Then replace with ^c after copying the first SEQ Mylist field. That worked a treat, so now I’m able to select and manipulate the references, turning them into superscript, or applying a style. I now need to select (probably using cut rather than copy) the references from the bottom of the document, and then insert them as footnotes in the relevant places. I figure the entire footnote can be selected using the wildcard search ([\(])([0-9]{1,2})([\)])*^13 … in order to select from the footnote number (e.g (1)) to the end of the paragraph. Now for the tricky bit: how do I automate that search, cut, search again and paste as footnote? Would it be better to split the footnotes out into a different documents? I’m not that well-versed in VBA, and my cursory googling hasn’t yielded any results. Perhaps this should be done with a macro instead? Any advice would be appreciated. Best, Duncan |
#2
|
||||
|
||||
Duncan
It should definitely be done with a macro. You need to provide a sample document containing a few of the endnotes and body content which includes the bracketed numbers. Also include a sample of how the numbering restarts for each chapter.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
footnotes, vba, wildcard searches |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Always convert text to number? | SoMany | Excel | 1 | 04-26-2021 02:09 AM |
Convert text to phone number in merge | ChrisComp | Mail Merge | 1 | 03-03-2020 10:39 AM |
Reliable way to convert text to number with a formula | levraininjaneer | Excel | 8 | 12-22-2019 04:47 PM |
How to convert text that is enclosed inside parenthesis in a word document into numbered footnotes? | BobT | Word | 5 | 07-27-2018 01:17 PM |
Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |