Greg,
Yes we have (CCI: 000123) and then someplace else, a naked instance of 000123. I can live with the macro picking up the naked occurrences as the 6-digit numbers all correlate to the same library.
As for expanding numerical ranges I figured it would take too much work but had to ask if there might be a simple solution.

As always, thanks for putting up with me and providing feedback in such a timely manner.

Considering this issue solved.