Extracting numbers from text

[adrief]

Good day

I have a list of mix text and numbers and would like to extract only the first set of numbers ie(122, 90, 84, 118.4, 128.9)
What formula can i use for this?

COIL112X2.5
COIL90X2.5
COIL84X2.0
COIL84X2.0
COIL84X2.0
COIL118.4X1.8
COIL118.4X1.8
COIL118.4X1.8
COIL118.4X1.8
COIL118.4X1.8
COIL118.4X1.8
COIL118.4X1.8
COIL128.9X2.0

 

[bosco_yip]

1] If the starting text always begin with "COIL", formula copy down :

=--MID(A1,5,SEARCH("x",A1)-5)

2] If the starting text does not in fixed length, formula copy down :

=-LOOKUP(1,-RIGHT(LEFT(A1,SEARCH("x",A1)-1),ROW($1:$30)))

Regards
Bosco

 

[adrief]

thank you it works