View Single Post
 
Old 06-26-2019, 08:27 PM
cheech1981 cheech1981 is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2011
Location: New Jersey, USA
Posts: 77
cheech1981 is on a distinguished road
Default

EDIT

Great Idea Kilroy. I was able to run your idea as a replace all to significantly decrease the work.

Now I'm going through one by one with the find-replace in the OP to reverse the rest. If anyone is doing in this in the future, you can't hit "replace all" in the second run for a few reasons. For instance, you will have to manually skip instances where it will catch "F., Last" (that is, the first initial from a previous name and the last name of the next author). You will also have to manually handle names that have triple initials, hyphenated last names, and names with multiple parts (e.g., "van something," "de something").

Looks like I would have to write some code in a macro to handle these special instances. For now the provided solution was quite useful to knock out a good chunk, and the find-replace in the OP at least lets me move quickly from instance to instance, skipping over the irrelevant ones and fixing the others. Thanks!

Last edited by cheech1981; 06-27-2019 at 09:17 AM. Reason: updated response after playing with it a bit
Reply With Quote