Validation

  • Thread starter Thread starter Juran
  • Start date Start date
J

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
 
Did you type the "=" sign before the LEFT(...), e.g.

=LEFT(C15,3)="WCA"

??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another question on Validation 3
Vlookup 4
Excel Counter 1
one page on website won't load in internet explorer 5
Conditional 6
Data validation error with multiple CPU 1
Enter x TAB 1
Need help with Data Validation Formula for a set of numerical andtext-based values 7

Back
Top