| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text string
I have a following formula to extact text string.
=IF(ISERROR(SEARCH("Blind Discount",A3)),"","Blind Discount") I want to add one more criteria. If the text string has "DLL" or "KEY" word in it, then I want result to be null otherwise "Blind Discount". thanks, Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text string to Numeric string | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Threaded Mode
