I would like to be able to validate only the first charater entered into a
cell. I'm going to be scanning a bar code label into a cell and I need to
validate that the correct bar code data has been scanned.

Example: P12345 is scanned into cell A1. Validation needs to be done on the
first character to determine if the (P) Part number has been scanned. If the
first character is not a "P" then display an error 'You must scan the part
number label'.

Any thoughts?

--
jaustin