View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Validation - Precede with LR and between 6 and 9 characters long.

Hi,
If you post your current data validation formula, we could probably help you
modify it.
Regards - Dave.

"forevertrying" wrote:

Hi,

I currently have a validation rule running whereby it will only allow a code
that starts with LR and is 6 character long i.e.

LR8976

I need it to allow for either 6 or 9, or allow for between 6 and 9.
Preferably one or the other as it leaves less room for error.

Can you help?