Extracting Numbers from text string

Hi All,

I have a column of text strings of various lengths and positions, I would like a formula to return just the numbers and the "." and "/" in between.

Below is an example of what the texts in each cell look like;

1 - O/N 213087/2300.4 ON HOLD SN
2 - O/N 213087/2300.11
3 - O/N 213087/2300
4 - G14 O/N 213087/2300.8

Using a formula, I would like to return below in the corresponding order.

1 - 213087/2300.4
2 - 213087/2300.11
3 - 213087/2300
4 - 213087/2300.8

Thank you

Does it always contain the O/N to start?

PL see file. UDF GetNumber is used.
code

Please Login or Register  to view this content.