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"?

With your text in A1 try:

--MID(A1,FIND("AGE",A1)+5,FIND(" ",A1,FIND("AGE",A1)+5)-(FIND("AGE",A1)+5))