Another question on Validation

J

Juran

Can I put two conditions as a cell validatiion?
Ex.
=left(c10,3)="TDI" and text lenght.

Thank you.

Juran
 
R

RagDyeR

For a total cell length of 10, try this:

=AND(LEFT(C10,3)="TCI",LEN(C10)=10)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Can I put two conditions as a cell validatiion?
Ex.
=left(c10,3)="TDI" and text lenght.

Thank you.

Juran
 
R

RagDyeR

Thanks for the feed-back.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

ragdyer

Thank you.

Rubem
 
Top