If you have *one* set of numbers in the string, with *no* spaces between the
numbers, try this *array* formula.

=--MID(A1,MATCH(FALSE,ISERROR(--MID(A1,ROW(INDIRECT("1:100")),1)),0),100-SUM
(--ISERROR(1*MID(A1,ROW(INDIRECT("1:100")),1))))

Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bhupinder Rayat" wrote in
message ...
Hi,

They do have spaces within them, but it is not as simple as that. integers
can be anywhere within the text string, even at the start of it. Your
formula
does not give me what I what. Thanks for the try, any other offers?

Regards,

Bhupinder

"Roger Govier" wrote:

Hi

DO they all have a space within them?
Do you always want whatever comes after the space?
If so
=MID(FIND(" ",A1)+1,255)

Regards

Roger Govier


Bhupinder Rayat wrote:
Hi all,

is it possilble to extract integers from a text string within a cell?

Eg.
Cell A1 - "ABC 123"
I want to extract the "123" from cell A1.

I have many text strings from which I need to extract the integers from.
The trouble is that each text string does not follow a consistent order,
so I
cannot use text functions such as LEFT, MID or RIGHT to extract what i
need.

Any help would be much appreciated.


Regards,


Bhupinder Rayat