Thanks Jacob. Perfect.
Regards - Dave.

"Jacob Skaria" wrote:

Dave

'to return the first position of a numeric within the text
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )

'So for your data
=--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),7)

--
Jacob


"Dave" wrote:

Is it possible to use the Search (or Find) function to find a number in a
text string?
eg SEARCH(CODE(<57),A1)
This doesn't work, but hopefully it gives an idea of what I'm after.
Ideally, I'd like:
SEARCH(CODE(48 to 57),A1)
Possible?
Regards - Dave.