Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract text within two specific values within a cell
I have a cell (D2) of wrapped text that contains two keywords: "NAME:" and
"CONSTRAINED". I want to extract all of the text between these two keywords and paste it in cell L2. I'm getting closer by using =MID(D2,SEARCH("NAME:",D2),30) to get the text that follows the first keyword "NAME:", but I am stuck now trying to determine how to get the extraction to stop when the query reaches the second keyword "CONSTRAINED". Your help would be much appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract text within two specific values within a cell
On Wed, 11 Feb 2009 08:30:03 -0800, Michelle
wrote: I have a cell (D2) of wrapped text that contains two keywords: "NAME:" and "CONSTRAINED". I want to extract all of the text between these two keywords and paste it in cell L2. I'm getting closer by using =MID(D2,SEARCH("NAME:",D2),30) to get the text that follows the first keyword "NAME:", but I am stuck now trying to determine how to get the extraction to stop when the query reaches the second keyword "CONSTRAINED". Your help would be much appreciated Search for "CONSTRAINED" and subtract from that your initial SEARCH to get the Number of letters. Note that your above formula will also extract the word NAME: which is not 'between'. Something like: =MID(D2,SEARCH("NAME:",D2)+6,SEARCH("CONSTRAINED", D2)-SEARCH("NAME:",D2)-7) will obtain the characters between the keywords. You need to also decide what you want to do about leading/trailing spaces and any included LineFeeds. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract a specific portion of text as new cell value | Excel Discussion (Misc queries) | |||
Extract specific text | Excel Worksheet Functions | |||
Formula to extract a specific word from text string | Excel Worksheet Functions | |||
Extract specific value from a long text string | Excel Worksheet Functions | |||
Extract Specific Text | Excel Worksheet Functions |