OpenOffice SEARCH function returning #value!

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! :super:

Agreed, kludgy indeed, but the boss doesn’t care (grin).  NB: I replaced the commas (,) with semicolons (;).

Advertisements