View Single Post
 
Old 11-13-2015, 10:12 PM
Peter_SSs Peter_SSs is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Nov 2015
Location: Macksville, Australia
Posts: 1
Peter_SSs is on a distinguished road
Default

Quote:
Originally Posted by Officer_Bierschnitt View Post
Can I implement some kind of data_validation so that people can only enter some real name, maybe based on the criterion that a real name has 2 or more segments?
To do that, and say the cell with the Data validation is cell A1, then in the DV dialog -> Settings tab -> Allow: Custom -> Formula: =FIND(" ",A1)
Reply With Quote