OpenOffice SEARCH function returning #value! Sep27 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 (;). Rate this:Share:TweetMorePrintEmailShare on TumblrRedditPocketLike Loading...