| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify search function
Hi,
I have following formula that needs to be modified. =IF(ISERROR(SEARCH("BOFA",V98)),"0",MID(V98,SEARCH ("- ",V98)+1,99)+0) Seconf search criteria which is "- " can be either "- " or "for". How can i incorporate the second criteria as "for"? Thanks, Dinesh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify array function length | Excel Worksheet Functions | |||
| Is there a way to modify the DAYS360 function to accomadate a 365 | Excel Worksheet Functions | |||
| How do I modify the autofit function in Excel? | Excel Discussion (Misc queries) | |||
| Can I modify cell attributes (font,color etc.) based on function . | Excel Discussion (Misc queries) | |||
| Can I modify a Hyperlink with a function? | Excel Discussion (Misc queries) | |||
Threaded Mode
