On Mon, 20 Jul 2009 07:48:01 -0700, Eric_NY
wrote:

I used the regex solution that Ron Rosenfeld suggested, and adjusted the
regular expression by removing the "\b" before and after the "\d{7}".


If you remove the "\b"'s, then the regex solution will return, for example, 7
digit portions of 8 digit numbers; or if you have an entry like NH123456789, it
will return 1234567. Is that what you want?
--ron