Extract a number from a text string

[dji]

Hi
Can you help with a formula solution for the following as I want to extract just the number from a string of text , in this case it is 150 but it could be a single digit like 5 , but in each case the amphersam appears after the number if that helps

/index.php?page=catalogue&vehicleid=150&make=TOYOTA&v_type=LANDCRUISER

Many thanks
Steve

 

[jasonb75]

Unfortunately the ampersand appears in several other places in the string, so it's not an ideal marker.

Is it always "vehicleid=#&" ?

 

[anandvarma]

try this
if b1 houses the text.

=LEFT(REPLACE(B1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B1&"0123456789"))-1,""),FIND("&",REPLACE(B1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B1&"0123456789"))-1,""))-1)

 

[dji]

Unfortunately the ampersand appears in several other places in the string, so it's not an ideal marker.

Is it always "vehicleid=#&" ?

yes it does always appear
thabks

 

[jasonb75]

anandvarma's suggestion should work, as should

=TRIM(LEFT(SUBSTITUTE(RIGHT(SUBSTITUTE(A1,"vehicleid=",REPT(" ",255)),255),"&",REPT(" ",255)),255))