Thread: [Solved] Restricting Cell Entry to "N12345678"
View Single Post
 
Old 11-27-2014, 10:03 AM
balbas662 balbas662 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Nov 2014
Posts: 2
balbas662 is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
Hi
in A2,try Data - Data Validation - Select " Custom" and enter following formula =AND(LEN(A2)=9,CODE(A2)=78,ISNUMBER(RIGHT(A2,8)*1) )

Adapt the cell to your needs

I'm not that great with Excel so this may be a noob question, but I wan the "N" to be constant but it can be lower case or upper case is that possible?

Thanks. Also I assume I hit the rep button to say thanks on this forum?
Reply With Quote