Hi

Is it possible to only allow data of a certain format to be entered in to a
cell. For instance a UK national insurance number that always has the same
format of two letters followed by six numbers and then either A, B, C or D
i.e YB123456A.

Many thanks for your help

Luke