Data validation, but is it possible?

[omairhe]

Hello,

I need a data validation to go in column A which have names of the articles . These names of articles in column A will have the first character capitalized and the very next one should be non-capitalized. The third character is of no importance and hence no data validation require for it.

eg. for data validation with error:

samsung
sAmsung
SAmsung
SAMSUNG


eg. for data validation without any error:

Samsung
SaMSUNG
SamSunG


Is it possible? TY

 

[lrobbo314]

Select the range that you want the validation to take place in. Then in Data validation, under Allow:, select custom and paste the following formula.

=AND(AND(CODE(MID(B1,1,1))>=65,CODE(MID(B1,1,1))<=90),AND(CODE(MID(B1,2,1))>=97,CODE(MID(B1,2,1))<=122))

Change the cell reference from B1 to whatever the first cell in your range is. Make sure it is a relative reference and not an absolute one, i.e. B1, not $B$1.

 

[omairhe]

Wow. this does the trick. Thanks.

 

[kvsrinivasamurthy]

For cell D2 the Formula for data vaidation

=AND(CODE(LEFT(D2,1))>=65,CODE(LEFT(D2,1))<=90)