Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation criteria
I have to restrict the number of characters in a cell that already has a data
validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation criteria
Since you're using data|validation and a list, couldn't you just make sure that
each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation criteria
The selections are from a very specific list - so the response choices are
limited. But I guess a space counts, though? So if I had a yes or no drop down and it had to be three characters long, I would just have no with a space? Is that what you mean? "Dave Peterson" wrote: Since you're using data|validation and a list, couldn't you just make sure that each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation criteria
That's exactly what I mean.
Greyling wrote: The selections are from a very specific list - so the response choices are limited. But I guess a space counts, though? So if I had a yes or no drop down and it had to be three characters long, I would just have no with a space? Is that what you mean? "Dave Peterson" wrote: Since you're using data|validation and a list, couldn't you just make sure that each entry in that list is exactly 30 characters. I'm not sure how you would reconcile that the string has to match something on the list--and at the same time be 30 characters long--if those entries on the list aren't 30 characters long. Greyling wrote: I have to restrict the number of characters in a cell that already has a data validation criteria of selecting from a named range. How do I apply the second criteria of saying that this selection now must be equal to 30 characters (I need to export to a text file that requires specific character lengths for each data element gathered). -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple validation criteria for one cell | Excel Worksheet Functions | |||
Can you create a LIST and DATA VALIDATION CRITERIA in same cell? | Excel Discussion (Misc queries) | |||
Data validation two criteria | Excel Worksheet Functions | |||
Validation - multiple criteria in one cell | Excel Discussion (Misc queries) | |||
Is the data validation criteria limited to a few number of items . | Excel Worksheet Functions |