Formula to extract a specific word from text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
With the text in A1
=IF(ISERROR(FIND("rejected",A1)),"","R")&IF(ISERROR(FIND("deleted",A1)),"","D")
Not sure the relevance of the cell holding the formula
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text string 2
Extract specific value from a long text string 4
extract cusotmer name from test string 5
extract word function 14
Extract text within ( ) 11
Extract value from a text string 11
Scrabble Value calculation for Welsh words 0
Nested formula to search a text string and return specific text 10

Back
Top