Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search Function
Hi,
Following function formula gives me a result like"Direct FundingsDirect Fundings". How can I modify the formula so that the result is "Direct Fundings" once instead of layers. I know my text string has both words "VAR" and "Intercompany" in it. =(IF(ISERROR(SEARCH("VAR",AC81)),"","Direct Fundings")&IF(ISERROR(SEARCH("Direct Funding",AC81)),"","Direct Fundings")&IF(ISERROR(SEARCH("Intercompany",AC81)) ,"","Direct Fundings") Thanks, Dinesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search Function | Excel Worksheet Functions | |||
SEARCH function help | Excel Worksheet Functions | |||
How do I add a search function? | New Users to Excel | |||
Search Function.. | New Users to Excel | |||
VBA Search function | Excel Discussion (Misc queries) |