Thread: Validation - Precede with LR and between 6 and 9 characters long.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
forevertrying forevertrying is offline
external usenet poster
  
Posts: 30
Default Validation - Precede with LR and between 6 and 9 characters long.
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?
Reply With QuoteReply With Quote