Linking two formulas for text conversions to numerical expressions

Data extract from xxx program gives quantities in a text format. I need to multiply the quantities and express them numerically.

Example:
Program output:
1 x 28 tablet pack
2 x 32 tablet pack
5 x 100 tablet pack
8 x 8400 tablet pack

After using the formula =LEFT(A2;SEARCH(" ";A2;1))*MID(A2;4;4)*1

28
64
500
6720

Which is what i need but when the first number is not single i.e.

12 x 28 tablet pack

I have to use formula =LEFT(A2;SEARCH(" ";A2;1))*MID(A2;5;4)*1 which gives the correct result.

How to link those formulas to create ONE formula that will work for both single and double digits???

just use this instead:

Please Login or Register  to view this content.

well, that uses comma-separation, you might have to swap those out for semicolons if that's what your excel settings are.

Thank you for the reply but this doesn't multiply the numbers.
If
1 x 28 tablet pack
the result should be 28
but if
2 x 32 tablet pack
the result should be 64
or if
12 x 28 tablet pack
the result should be 336

=IF(FIND(" ",A4,1)=2, LEFT(A4,SEARCH(" ",A4,1))*MID(A4,4,4)*1,LEFT(A4,SEARCH(" ",A4,1))*MID(A4,5,4)*1)

Worked!

Thank you very much!

with the MID explicitly wrapped into your existing function:

Please Login or Register  to view this content.