Extract number in middle of cell

Given your examples, you could use:

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)*1

Test it on several other examples. It may fail if your other examples don't
follow a similar pattern.

HTH
Jason
Atlanta, GA

"SCOOBYDOO" wrote:

> 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 ; )

=--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" <[email protected]> wrote in message
news:[email protected]...
> 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 ; )

Given your examples, you could use:

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)*1

Test it on several other examples. It may fail if your other examples don't
follow a similar pattern.

HTH
Jason
Atlanta, GA

"SCOOBYDOO" wrote:

> 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 ; )

=--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" <[email protected]> wrote in message
news:[email protected]...
> 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 ; )

Given your examples, you could use:

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)*1

Test it on several other examples. It may fail if your other examples don't
follow a similar pattern.

HTH
Jason
Atlanta, GA

"SCOOBYDOO" wrote:

> 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 ; )

=--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" <[email protected]> wrote in message
news:[email protected]...
> 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 ; )

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 ; )

Given your examples, you could use:

=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)*1

Test it on several other examples. It may fail if your other examples don't
follow a similar pattern.

HTH
Jason
Atlanta, GA

"SCOOBYDOO" wrote:

> 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 ; )

=--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" <[email protected]> wrote in message
news:[email protected]...
> 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 ; )