Extracting all numbers from a cell?

[Shelter417]

Hello,

Sometimes I use the following formula to extract numbers from a cell that has both text and numerals:

=LOOKUP(99^99,--("0"&MID(H66,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},H66&"0123456789")),ROW($1:$10000))))


While this works well when there's only one number in the cell, if there are multiple numbers, it only returns the first one. For example, if this is cell H66:

"NAME 3:90-125. 1959."

...the string only returns "3." Is there a way to return "3," "90," "125," and "1959" in separate cells?

[taps]

Hi,

Could you please explain how your above formula works. I have checked it. It's fantastic.

Thanks
taps

[Shelter417]

I can't take credit for it. I found it on this thread:

http://www.excelforum.com/excel-form...ic-string.html

There's a good explanation in post #10.