Numbers stuck in strings. Does this number belong?
Hello,
I have a string that resembles 1,2,5-7,13. I have another cell that has a number in it. I want to know if that number is in the first number.
So if I have:
1 - I want to return true
2 - I want to return true
6 - I want to return true (6 is not one of the numbers in the string but it is between 5 and 7.
10 - I want to return false
Kind Regards,
Jay
|