Thread: Formula to extract a specific word from text string
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
  
Posts: 320
Default 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 With QuoteReply With Quote