You've already helped me out so much and I was able to find a way to extract the text to another document, but can I ask for one more thing?

Some of the numbers have facility codes that are attached to the equipment numbers with a hyphen (e.g. N50-V12345). Can the macro you created include the hyphen when capturing the text? At the moment it will get the N50 and the V12345 as seperate highlights not including the -.

If this can't be done, it really is no problem. I'm already super happy about all the help I've already gotten.