View Single Post
 
Old 05-20-2017, 09:19 AM
teligence teligence is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Aug 2016
Posts: 2
teligence is on a distinguished road
Default Search for specific data in a text string

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"?
Reply With Quote