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