Add a restriction to a column
Solved/Closed
Aimz
-
Dec 3, 2015 at 05:16 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 3, 2015 at 11:51 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 3, 2015 at 11:51 AM
Related:
- Add a restriction to a column
- Why can't i add a contact to whatsapp - Guide
- How to add an accent to an e - Guide
- Ms office add on pdf - Download - Other
- How to add featured channels on youtube - Guide
- Thunderbird add signature - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Dec 3, 2015 at 11:51 AM
Dec 3, 2015 at 11:51 AM
you have to use validation with custom formula
is validates your check of starts with 03 and length = 11
=AND(LEFT(A1,2)="03", LEN(A1)=11)
is validates your check of starts with 03 and length = 11
=AND(LEFT(A1,2)="03", LEN(A1)=11)