Problem Creating Custom Cell Validation Formula

[Ark68]

I am trying to create a custom formula for cell validation, but I'm not getting the results I am looking for with this:

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.

 

[Fluff]

Instr is a vba function, not an xl one. Try

=AND(ISNUMBER(FIND(",",D4)),LEN(D4)>3)

 

[Ark68]

Yeah! Nice Fluff, thank you.

 

[Fluff]

You're welcome & thanks for the feedback.