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
|