Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2021, 11:43 PM
Aldous huckster Aldous huckster is offline Convert text to footnotes based on reference number Windows 10 Convert text to footnotes based on reference number Office 2016
Novice
Convert text to footnotes based on reference number
 
Join Date: Jul 2021
Posts: 1
Aldous huckster is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-15-2021, 12:09 AM
Guessed's Avatar
Guessed Guessed is offline Convert text to footnotes based on reference number Windows 10 Convert text to footnotes based on reference number Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,739
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

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
Reply With Quote
Reply

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
Convert text to footnotes based on reference number 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft