I need a formula that shows a numeric result for 1 - 3 digit "number as text" found in a text string.
Example text:
FULL NAME: Ean Tralfaz AGE: 23 YEARS EMPLOYED: 9
Notes:
There is always a single space after a label's colon
There is always a single space after a label's value
The length of a label's result varies
In this example, is there a way to search for "AGE:" and show numeric result for "23"?