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.