Hi,

I refer to a previous equation I've seen on the forum and I want to extract numbers from a sentence and have it onto another row.

eg. A1: 1 ALL OTHERS

to have 1 on say K1

I used the following equation:

=LOOKUP(99^99,--(0&MID(RC[-8],MIN(FIND({0,1,2,3,4,5,6,7,8,9},RC[-8]&1234567890)),ROW(INDIRECT("1:"&LEN(RC[-8])+1)))))

However, I got 0.0417.... instead. I do not know how to edit the equation though because for some of the rows it works fine but some doesnt.

Thank you in advance!