I'm not sure what you mean by "numbers that are part of other strings".
I thought that's what was wanted but i'm probably missing something.

As Rick states the requirements are not clear enough on this.

"Ron Rosenfeld" wrote:

On Sat, 18 Jul 2009 02:26:01 -0700, Lori
wrote:

After further investigations, i think i've got a simplified version:

=LOOKUP(1E8,--(MID(A4&".",COLUMN(A:IV),7)&" 0/1"))

which returns the last 7 digit integer and errors if none is found.
[&" 0/1" ensures only integers are returned; &"e0" would return decimals too]

It also returns seven digit numbers that are part of other strings, including
longer strings of digits.
--ron