Use Validation to force specific entry of first 3 characters in st
 

What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".

Use Validation to force specific entry of first 3 characters in st
 

Hi

An example for column A, the formatting starts from A1
=(LEFT($A1,3)="PR-")

Whe you also need all entries to be unique, then
=AND(LEFT($A1,3)="PR-",COUNTIF($A:$A,$A1)<2)


Arvi Laaneemts


"ron" wrote in message
...
What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".

Use Validation to force specific entry of first 3 characters in st
 

=LEFT(A1,3)="Pr-"
or maybe...
=EXACT("PR-",LEFT(A1,3))

(with A1 being validated.)

ron wrote:

What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".

--

Dave Peterson

Use Validation to force specific entry of first 3 characters i
 

You people are really really good. Thanks. I modified the formula to ensure a
6 digit entry:
=AND(LEFT(E26,3)="Pr-",LEN(E26)=6)

"Dave Peterson" wrote:

=LEFT(A1,3)="Pr-"
or maybe...
=EXACT("PR-",LEFT(A1,3))

(with A1 being validated.)

ron wrote:

What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".

--

Dave Peterson

Use Validation to force specific entry of first 3 characters i
 

You people are really really good. Thanks. I modified the formula to ensure a
6 digit entry:
=AND(LEFT(E26,3)="Pr-",LEN(E26)=6)

"Arvi Laanemets" wrote:

Hi

An example for column A, the formatting starts from A1
=(LEFT($A1,3)="PR-")

Whe you also need all entries to be unique, then
=AND(LEFT($A1,3)="PR-",COUNTIF($A:$A,$A1)<2)


Arvi Laaneemts


"ron" wrote in message
...
What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".