That worked well on the #2 sub-strings that are all numeric. I have some #2 sub-strings that are alpha-numeric, and it appears to return #VALUE! on those.

I don't have too many of those, and could correct those manually, if there is no easy solution.

Thank you for all your help. It is late here, and I will do some experimenting tomorrow and reply if I have more questions.