View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
antinoz antinoz is offline
external usenet poster
 
Posts: 9
Default cell validation/format masks???

Hi Everybody

I have a list of cells with alphanumeric data in it eg ("01R1234567")
I want to write an if statement to check that the contents of the cells is a
valid reference.

Is there any way to check the individual characters for there values
eg IF A1 = "NNANNNNNNN" Then B1 = "valid" (N=numberic A=Aplph)
else B1 = "corrupt"
End If

Thanks
Anthony