=--MID(A1,FIND(" ",A1)+1,FIND("^",SUBSTITUTE(A1," ","^",2))-FIND(" ",A1)-1)
provided your cell always contains text then a space then number and then a
space

"SCOOBYDOO" <SCOOBYDOO@discussions.microsoft.com> wrote in message
news:8A148128-2B26-40D8-8F99-A4E34AB6B2F7@microsoft.com...
> Hi, does anyone know how I extract a number if it appears in the middle of
> a
> cell but not necessarily at the same point in i.e. 'buy 35 products',
> 'sell
> 40 products'. Thanks in anticipation ; )