Extract Number from text

**mohd_arastu** · 12-16-2011, 03:26 PM

hello friends,
i want to extract numberfrom text.
for example
if A1= Rect 0.60x0.38
i want the result as
B1=0.60
C1=0.38

plz help me

Thanks

**Haseeb Avarakkan** · 12-16-2011, 03:57 PM

If your data is as posted ( only 1 x between numbers no where else, only 1 space before the 1st number no where else)

Try this,

B1,

=MID(A1,SEARCH(" ",A1),SEARCH("x",A1)-FIND(" ",A1))+0

C1,

=MID(A1,SEARCH("x",A1)+1,250)+0

If not,

B1,

=LOOKUP(9E300,--RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",50)),{1,2,3,4,5,6,7,8,9}))

C1,

=LOOKUP(9E300,--LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",50)),50)),{1,2,3,4,5,6,7,8,9}))