Validation

[Juran]

I am trying to use this formula LEFT(C15,3)="WCA" to
validate an entry , but it is not working.

Any suggestion?

Thank you.

Juran

 

[JE McGimpsey]

Did you type the "=" sign before the LEFT(...), e.g.

=LEFT(C15,3)="WCA"

??

 

[Juran]

JE,

Thank you.

Yes, I forgot to include =.

Juran