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 |
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 |