Hi there,

should be so easy, but I can't get it working:

I'm using this Formula to get a "1" Value when FIND a "-" symbol in a Cell two columns to the right.
Can anyone tell me, why it's not working. It always shows #VALUE!



Thank you

Found it by myself. It hast to be:

Hi and thank you for sharing the solution

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you ! That's it.