EXTRACT specific number to the left of specific text

[Phil_Waite]

Hi,

I have some text in a long text column. The text often says “8 apples” at some point in the text.

Can I use EXTRACT to isolate the number 8?

I can do this in the sheet but would prefer to do in appsheet

Also can I EXTRACT the two digits before “apples” in case there are 10 or 11.

Thanks

Phil