OpenOffice SEARCH function returning #value! Sep27 by James Carroll Thank you, matic, for your solution: Sat Apr 07, 2012 5:29 pm =IF(NOT(ISERROR(FIND(“John”;D2)));John;”") It’s a bit [kludgy], but it works! Agreed, kludgy indeed, but the boss doesn’t care (grin). NB: I replaced the commas (,) with semicolons (;). About these ads Rate this:Share this:More Pin ItPrintEmailLike this:Like Loading...
=IF(ISERROR(FIND(“John”;D2)));””;John)
Does this not give the same result with one less kludge?
@larikaz, Oh, yeah, that should work; I haven’t tested it yet. Thanks for the tip!