Thread: alpha numeric data validation for excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] brdoel@gmail.com is offline
external usenet poster
  
Posts: 1
Default alpha numeric data validation for excel
I want to use a non vb formula in data validation for an excel formula
to make the user enter the first 2 characters of a field as UPPERCASE
letters i.e. AB12345 - the format is always the same 2 letters 5
numbers.

Any ideas?
Reply With QuoteReply With Quote