Extract numbers from text

[faris_dxb]

Could you please help me with that??

I have list of text which contains serial numbers and I want to extract these serial numbers which start with 000 to another column. How to do that.

Example

A1:
Asdf asdf asdf asdf asdf asdf asdf 0001234567 asdf asdf asdf asdf asdf

A2:
Asdf asdf asdf asdf 0001234567 asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf

A3:
asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf 0001234567 asdf asdf asdf asdf asdf asdf 0001234567 asdf asdf asdf



please help me with that

[/SIZE]

[Richard Buttrey]

Hi,
One way:

Please Login or Register  to view this content.

I noted that not all the 'spaces' were consistent spaces, i.e. ASCII 32
the first 'space' after the number in the third example was ASCII 160, a non breaking space. The formula above assumes all spaces are ASCII 32

Rgds