I have a spreadsheet where in one column the users must input alphanumerics, but no special characters, and another column where they should only input numbers. Both of these cases are issues where they have a tendency to input things that shouldnt be there which causes alot of problems with the rest of the spreadsheet, how do i prevent those things from being input into the cells (without using macros)?
Bookmarks