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

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

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

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

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