Data validation the other way round?

		Microsoft Office Forums > Microsoft Excel > Excel
Data validation the other way round?

FAQ

Thread Tools

Display Modes

11-13-2015, 10:12 PM

Peter_SSs

Windows 7 64bit Data validation the other way round?

Office 2010 32bit

Novice

Join Date: Nov 2015

Location: Macksville, Australia

Posts: 1

Quote:

Originally Posted by Officer_Bierschnitt

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)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste over data validation	saurabhlotankar	Excel Programming	2	05-24-2015 11:52 PM
data validation from another sheet	paulys	Excel	1	06-30-2014 01:40 AM
Data Validation drop down	rkalapura	Excel	1	05-27-2012 02:23 AM
If/then formulas with data validation	shira47	Excel	1	04-09-2012 05:14 AM
Data validation with IF	Klyxrastafari	Excel	1	10-03-2011 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.