Hi,

Yea the formula works like a charm. I have used array formulas before, it
didnt accept the formula because the 2nd line of the formula got pasted into
a the new line. Its been a long day!!

thanks guys.


Bhupinder.

"David Billigmeier" wrote:

RagDyeR's formula worked for me. Remember you have to enter the formula by
pressing CTRL+SHIFT+ENTER... **NOT** just Enter. The "--" is for changing
boolean TRUE/FALSE valuse to 1/0 so multiplication/addition can take place.

--
Regards,
Dave


"Bhupinder Rayat" wrote:

RayDyer,

I can see wat are trying to achieve, it may work, but excel does not like
the formula.
You have inserted "--" within the formula, what is this for?

Regards,

Bhupinder

"RagDyeR" wrote:

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