Hey guys,
I am trying to set a validation rule on MS Excel 2010 that only lets you enter a certain pattern of characters.
The data I am trying to enter in are ID numbers, for example AA101 E.
The general pattern to be: Letter, Letter, Number, Number, Number, Space, Letter

Can anyone tell me how I do this?

Thanks in advance.