ASAP Utilities, a free add=in available at www.asap-utilities.com includes a
feature that will do what you want.

Vaya con Dios,
Chuck, CABGx3



"Michael M" wrote:

Hi All
I did a search in the archives for a way to strip all occurences of text
from a cell of numbers, eg,
A3F4DR5V1, would end up being 3451.
I found a post from Bob Phillips ( thanks Bob),with the following formula:

=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),ROW(INDIRECT("4:"&LEN(A1)))))

but it doesn't work, I've tried using CSE but I still get a #N/A error.
Can anybody please tell me where it's not working.
I can do it with code but would rather keep the OP away from macros.

Regards
Michael M