On Tuesday, May 8, 2018 at 2:58:14 PM UTC-4, jlclyde wrote:
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

Cross-post: https://groups.google.com/forum/#!to...sc/DTw02f3uFW4