#1
|
|||
|
|||
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: 9Notes: There is always a single space after a label's colonIn this example, is there a way to search for "AGE:" and show numeric result for "23"? |
#2
|
|||
|
|||
With your text in A1 try:
--MID(A1,FIND("AGE",A1)+5,FIND(" ",A1,FIND("AGE",A1)+5)-(FIND("AGE",A1)+5)) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color | jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
Search for multiple texts in cell, return specific text | mariur89 | Excel | 4 | 12-14-2014 01:33 AM |
Search first section for specific string... | donaldadams1951 | Word VBA | 4 | 03-14-2014 11:24 AM |
Way to search for a string in text file, pull out everything until another string? | omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Convert numbers to a specific text string | francis | Excel | 1 | 10-06-2011 01:43 PM |