View Single Post
  #25   Report Post  
Old March 17th 16, 09:16 PM posted to microsoft.public.excel.worksheet.functions
comin comin is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2016
Posts: 1
Default alpha numeric data validation for excel

On Saturday, 29 November 2008 04:23:44 UTC+11, wrote:
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?




On Saturday, 29 November 2008 04:23:44 UTC+11, wrote:
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?