capture number from a cell

[b19upj]

HI,

I have a large number of rows with characters and numerals in it.
They mostly (but not all) follow a similar combination to this:
xxxx - 12 - xxxxxxxx
or
xxxx - 123 - 456 xxxxxxx
or
xxxx - 1234 - 56 xxxxxxxx

I would like to pull out the first set of numbers only into a separate column

Any ideas?

 

[Arithos]

Hi sir,

Place your text string in cell A1, and use this formula,

=MID(A1;SEARCH("- ";A1)+2;SEARCH("- ";MID(A1;SEARCH("- ";A1)+2;LEN(A1)))-2)

I use EU seperators ";" change to "," for US



** EDIT; this assumes you will always have the "- " in your "text strings"