Hi Everyone,
First of all, thanks if you are reading my query. I have been struggling to find a formula that will allow me to restrict cell entries only to alphanumeric and 12 characters. I have been searching in the forums and google and could only find solutions for alphanumeric or length or restricting the length with alphanumerics but that also with fixed condition such as the alphabets need to be the first characters, etc etc.
Requirement:
1. What I need is, the cell will allow only alphanumeric (no specific order or sequence). it can be "US2K34675896", "FYIJ9101112", anything.
2. The cell will only allow 12 characters (the allowable alphanumerics) to be entered, not less not more.
It will be a great help if you could provide me with a solution.
Thanks in advance
Tamjid
First of all, thanks if you are reading my query. I have been struggling to find a formula that will allow me to restrict cell entries only to alphanumeric and 12 characters. I have been searching in the forums and google and could only find solutions for alphanumeric or length or restricting the length with alphanumerics but that also with fixed condition such as the alphabets need to be the first characters, etc etc.
Requirement:
1. What I need is, the cell will allow only alphanumeric (no specific order or sequence). it can be "US2K34675896", "FYIJ9101112", anything.
2. The cell will only allow 12 characters (the allowable alphanumerics) to be entered, not less not more.
It will be a great help if you could provide me with a solution.
Thanks in advance
Tamjid