Someone else may have a better answer , but the Search function can find char
within a cell and return the position.

I also like the answer on another sheet , put all the options and define
that list as "list1" then do a data validate / list as =list1


" wrote:

Hello

I am trying to have data validation for a cell which only allows users
to enter numbers [0-9] , comma (,) , hyphen (-) and space. User should
be able to enter a combination of these characters.

For Eg: 3, 45-60

I have used this formula
=OR(F8=" ",F8="-",F8=",",F8="0",F8="1",F8="2").

But the problem with this is it allows as long as user enters any one
of these character, if they enter multiple it doesnt allows them to.

Can anyone help me please?