| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to extract a specific word from text string
I have a long text string. Within the text string, there is always a word
either "deleted" or "rejected". I like to equate the word "deleted" as "D" or "rejected" as "R". What will be my formula. Assume the formula is on "A2". Thanks in advance for the help. Dinesh |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to extract a specific word from text string
Try this: =IF(FIND("deleted",A2,1),"D","R")
Dave -- Brevity is the soul of wit. "Dinesh" wrote: I have a long text string. Within the text string, there is always a word either "deleted" or "rejected". I like to equate the word "deleted" as "D" or "rejected" as "R". What will be my formula. Assume the formula is on "A2". Thanks in advance for the help. Dinesh |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to extract a specific word from text string
Actually, use this: =IF(ISERROR(FIND("deleted",D7,1)),"R","D")
Dave -- Brevity is the soul of wit. "Dinesh" wrote: I have a long text string. Within the text string, there is always a word either "deleted" or "rejected". I like to equate the word "deleted" as "D" or "rejected" as "R". What will be my formula. Assume the formula is on "A2". Thanks in advance for the help. Dinesh |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to extract a specific word from text string
With the text in A1
=IF(ISERROR(FIND("rejected",A1)),"","R")&IF(ISERRO R(FIND("deleted",A1)),"","D") Not sure the relevance of the cell holding the formula best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dinesh" wrote in message ... I have a long text string. Within the text string, there is always a word either "deleted" or "rejected". I like to equate the word "deleted" as "D" or "rejected" as "R". What will be my formula. Assume the formula is on "A2". Thanks in advance for the help. Dinesh |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to extract a specific word from text string
=SUBSTITUTE(SUBSTITUTE(A1,"deleted","D"),"rejected ","R")
"Dinesh" wrote: I have a long text string. Within the text string, there is always a word either "deleted" or "rejected". I like to equate the word "deleted" as "D" or "rejected" as "R". What will be my formula. Assume the formula is on "A2". Thanks in advance for the help. Dinesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Extract Text From Word Table Into Excel? | Excel Discussion (Misc queries) | |||
| Finding specific text in string - Part II | Excel Worksheet Functions | |||
| Finding specific text in a string | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Linear Mode
