| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Validation starting with 2 char & total less than 8 charact
Can a custom data validation formula be written for a cell to only allow a
user to enter a maximum of 8 characters (<=8) AND begin with the letters AD? Thanks! -- carusso |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Validation starting with 2 char & total less than 8 charact
=AND(LEN(A1)<=8,LEFT(A1,2)="AD")
-- David Biddulph "carusso" wrote in message ... Can a custom data validation formula be written for a cell to only allow a user to enter a maximum of 8 characters (<=8) AND begin with the letters AD? Thanks! -- carusso |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Validation starting with 2 char & total less than 8 cha
Hi David, thanks for your response.
I am trying to do this with Data/Validation/(Allow)Custom. I entered this formula in the formula field there, but it is not working. If I try entering text that is in compliance with the formula, I get the Stop error message. Cheryl -- carusso "David Biddulph" wrote: =AND(LEN(A1)<=8,LEFT(A1,2)="AD") -- David Biddulph "carusso" wrote in message ... Can a custom data validation formula be written for a cell to only allow a user to enter a maximum of 8 characters (<=8) AND begin with the letters AD? Thanks! -- carusso |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Validation starting with 2 char & total less than 8 cha
If your cell is not A1, did you remember to change the reference in the
formula? It works for me. -- David Biddulph "carusso" wrote in message ... Hi David, thanks for your response. I am trying to do this with Data/Validation/(Allow)Custom. I entered this formula in the formula field there, but it is not working. If I try entering text that is in compliance with the formula, I get the Stop error message. Cheryl -- carusso "David Biddulph" wrote: =AND(LEN(A1)<=8,LEFT(A1,2)="AD") -- David Biddulph "carusso" wrote in message ... Can a custom data validation formula be written for a cell to only allow a user to enter a maximum of 8 characters (<=8) AND begin with the letters AD? Thanks! -- carusso |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Validation starting with 2 char & total less than 8 cha
oooops.... ;-)
Works great now....thanks! -- carusso "David Biddulph" wrote: If your cell is not A1, did you remember to change the reference in the formula? It works for me. -- David Biddulph "carusso" wrote in message ... Hi David, thanks for your response. I am trying to do this with Data/Validation/(Allow)Custom. I entered this formula in the formula field there, but it is not working. If I try entering text that is in compliance with the formula, I get the Stop error message. Cheryl -- carusso "David Biddulph" wrote: =AND(LEN(A1)<=8,LEFT(A1,2)="AD") -- David Biddulph "carusso" wrote in message ... Can a custom data validation formula be written for a cell to only allow a user to enter a maximum of 8 characters (<=8) AND begin with the letters AD? Thanks! -- carusso |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto row height a cell with wrap text enabled and a lot of charact | New Users to Excel | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| Total 12 columns starting with first non blank column | Excel Worksheet Functions | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| Using custom functions within custom validation | Excel Discussion (Misc queries) | |||
Linear Mode
