I have a list of 1000+ names of people.
Created a data validation list. Validation alerts me if I type anything wrong in the validation list.
(Since the list is long I prefer typing or copying the name in the validation list column)
The problem arises when I copy paste the name.
Validation list accepts names copy pasted in any manner.
(It even accepts spelling mistakes...!!!)
Have attached sample sheet for reference. Highlighted in Yellow is where the data validation is created.
Any suggestion is welcome.
Since the actual excel where I want to use is heavy (very heavy) not a fan of macro.
Can make an exception if the macro is short.