I am using the find function to split cell strings into pieces. It works fine (mostly), unless the find fails in which case I get #NAME? for the value.
Really would I am trying to do is something like this:
=if(Find("x", G1, 1), "True Value", "False Value")
This sometimes gives the #NAME? value and so I refined the function to see where it is exploding and it is the FIND function, when it fails to find.
Any suggestions here would be greatly appreciated.