View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
KLZA KLZA is offline
external usenet poster
 
Posts: 64
Default VALIDATION USING ALPHA-NUMERICS ONLY - NO SPECIAL CHARACTERS

yes, 0-9 and a-z only...

On Aug 9, 5:06 pm, "Peter T" <peter_t@discussions wrote:
What about non Latin and/or accented characters, to clarify do you mean only
[A-Z, a-z, 0-9].

Regards,
Peter T

"KLZA" wrote in message

oups.com...



By alphanumeric i mean letters (alpha) and numbers (numerics) only..
no !@#$%^&*(*) <---- not a curse word :) etc... thanks!


On Aug 9, 2:55 pm, KLZA wrote:
Hi. Is there a simple validation formula that would restrict a cell
to alpha-numerics only and exclude all other characters? Thanks in
advance. :)- Hide quoted text -


- Show quoted text -