Hello,

I am struggling to write a formula to validate an ID Number.

Here are the valid options -
1) All numeric 10 character ID (example: 1234567890)

2) Alphanumeric 10 character ID, with the 9th character being a Alpha
character (example: 12345678E0)

3) Alphanumeric 14 character ID, with the 9th character being a Alpha
character (example: 12345678A01234)


The following examples have been used, but are not acceptable -
1) 1234567*9
2) 1234567*901234
3) 12345678'9
4) 12345678,9


Any help will be greatly appreciated.
Thanks
Ruan