Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,562
- Office Version
- 365
- 2016
- Platform
- Windows
I am trying to create a custom formula for cell validation, but I'm not getting the results I am looking for with this:
Cell must be more than 3 characters and contain a comma.
It doesn't matter what I enter now, it errors. eg: Doe, John results in an error.
Code:
instr(D4,",") =0 or len(d4) < 3
Cell must be more than 3 characters and contain a comma.
It doesn't matter what I enter now, it errors. eg: Doe, John results in an error.