Formula between x and space

[hasters]

HI gurus

I need a formula which will allow me to get the number between the x and the space. example below and spreadsheet attached

For example in column A i have
Milo Drink 3x200ml
Kombucha Wonder Traditional 10x414ml


IN column b i need

3
10

Many thanks

[shukla.ankur281190]

Try

B2=RIGHT(LEFT(A2,FIND("x",A2)-1),2)+0

[hasters]

Perfect, thank you

[shukla.ankur281190]

Glad it helps you and Thanks for feedback and Rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Phuocam]

Cocoxim 12x330ml

[shukla.ankur281190]

Cocoxim 12x330ml

You are right Phuocam then

=LEFT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",99)),99)),"x",REPT(" ",99)),99)+0

this would be good