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
|