Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula}"

In A1 MY WORLD - AUSTRALIA BIB, 300 CL

In B1
=MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),COUNT(1*MID(MID(A1,MIN(SEARCH({0,1,2,3,4, 5,6,7,8,9},A1&"0123456789")),99),ROW($1:$9),1)))

If this post helps click Yes
---------------
Jacob Skaria


"tomjoe" wrote:

Hi
I try to extract part of a text:
I want to extract the numbers 300, 200 and 5 in the column to the right of
the textstrings under.
MY WORLD - AUSTRALIA BIB, 300 CL
SAVANNAH CHARD FLO-FAIRTRADE BIB, 200 CL
HAMMER LONDON DRY GIN (USA), 5 CL

I have tried:
=MID(B257,FIND(",",B257,1)+1,LEN(B257))
This gives me also the CL (i.e. 300 CL).
Someone who now how I can fix this?


Tommy