Data Validation for multiple product codes

I have two types of product codes V###### and C######. All codes are six digits with either a "C" or "V" in front. I want to set the data validation to allow for either the "V" or "C" followed by six digits. The formula I am currently using is =AND(LEFT(I3,1)="V",LEN(I3)>6). However, this only allows for the V###### to be used. I cannot figure out how to add an additional formula to allow for the "C" to be used as well. Can anyone help?

Hello and welcome to the forum.

Try this:

=AND(OR(LEFT(I3,1)="V",LEFT(I3,1)="C"),LEN(I3)>6)

Note that you can remove the ",1" parts of the LEFT function since omitting them defaults to 1.

Also, you might consider changing >6 to =7 to not allow something like this: V1234567

Thank you so much. I have been trying so many versions of OR formulas. I was very frustrated. It works. I couldn't be happier.

Great, happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.