Add a restriction to a column

Question

Add a restriction to a column

Solved/Closed

Aimz - Dec 3, 2015 at 05:16 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Dec 3, 2015 at 11:51 AM

Hello,

Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should start from 03 then other 9 characters are to be added) is there a formula, can this be done.
Thank you for your time :)

Add a restriction to a column
Add same value of a column ✓ - Forum - Office Software
If a column has a value add to another column? ✓ - Forum - Excel
Need to find a data in a column and copy below cell data or add ✓ - Forum - Excel
Look at column and match and add this text te ✓ - Forum - Office Software
With picture names in column, add picture to fit cell dimensions ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2015-12-03T11:51:07-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
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)

Add a restriction to a column

1 reply

Your reply

Subscribe To Our Newsletter!