Hi,

This is for a soccer game report, in which the numbers before the slash are the jersey number of the scorer, and the numbers after the slash represent the time of the goal, expressed as a minute reference, e.g. 78 = 78th minute of the game.

The organization I work for has a terrible time in getting users to input data correctly according to this format, so it was my task to see if we can restrict users to entering data in this format or else the cell would reject the input. I've found the closest thing to a solution to be the data validation feature but I'm stuck on the code.

Recap, I've got the formula working for ##/##' and ###/###', but the formula bar seems to cap off at a certain point, so I cannot add on the formats ##/###' and ###/##'. I can easily rework the formula so that any 2 of these formats is included, but not all 4.