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