AwesomeSteph
Board Regular
- Joined
- Aug 18, 2017
- Messages
- 80
I have a column in an excel sheet that users input data I want to make it so they can't miss something important. Using data validation custom formula works great to ensure the user only inputs ##-##-##[A-Z]###
however I want to be able to allow them to add multiple entries into a cell with only that criteria. Is it possible in data validation to do this?
however I want to be able to allow them to add multiple entries into a cell with only that criteria. Is it possible in data validation to do this?