I have a text field for example:
There are 8% of people who wear red
I'd like to extract whatever number is before the "%" sign.
I got as far as =MID(AJ2,FIND("%",AJ2)-3,LEN(AJ2)) which kind of works but leaves everything after the % sign. I just want the number ideally.
Also some of the...