If you have forgotten the letter of your DNI, do not worry, calculating it is easy through three simple methods that you can carry out from your mobile or your computer.
The National Identity Document is the main identification document in Spain, and each ID number is accompanied by a letter. But, Have you ever wondered how the letter of the DNI is calculated and what it is for?
Although most people memorize their ID number and letter, it is possible that carelessness or forgetfulness arise at inopportune moments and when it is most necessary to have that information at hand.
For example, it is possible that someone has given you only their ID number and forgot to give you the letter. Therefore it is important to know that there are three infallible methods to calculate said letter, either through a mathematical formula, the use of Excel or through online websites.
All these resources offer the possibility of quickly obtaining the letter corresponding to the DNI number, guaranteeing correct identification and avoiding inconveniences in procedures and procedures.
However, there are some lesser-known details about this system, for example, not all the letters of the alphabet are used in the DNI. The letters I, O and Ñ are excluded for specific reasons, while the absence of the letter I and the O are removed to avoid confusion with the numbers 1 and 0 due to their similarity of spelling.
Mathematical formula to calculate the letter of the DNI
The traditional method for calculate the letter of your identity document It is using a mathematical formula that is quite simple to carry out.
You just have to take the ID numbers, divide it by 23 and write down the rest of the division. Now consult the correspondence table, which assigns each remainder a specific value in letter form:
The letter resulting from the previous table is the one that you must add to the DNI number to obtain the complete number. For example, in the case of 12345678, the remainder of the division is 14, so the corresponding letter would be Z, therefore, the complete DNI number would be 12345678-Z.
Nevertheless, an important point to mention is that the remainder has to be rounded offthis is done by eliminating the decimals, this is the only simple method to be able to associate it with a letter.
How to calculate the letter of your DNI in Excel
If it is difficult for you to make a division, you can always choose to rely on a digital tool such as Excel, the Microsoft office program to calculate the letter of your identity document.
For calculate the DNI letter in Excel you just have to do the following:
- Open a spreadsheet in Excel.
- In a cell, enter the ID number without the letter.
- In another cell, use the formula =RESIDUAL(A1,23) to find the remainder of the division.
- Consult the correspondence table above or the function VLOOKUP to get the corresponding letter.
- Finally, combine the ID number and the resulting letter to obtain the complete number.
- You can also use EXTRAE to extract the letter automatically, it is done like this in cell B1: EXTRAE(“TRWAGMYFPDXBNJZSQVHLCK”;RESIDUO(A1;23)+1;1)
Calculate the letter of the DNI online
Lastly, the easiest option is to make use of specialized web pages that offer DNI letter calculators. These online sites get you out of trouble instantly, as they perform the calculation automatically, saving you time and a lot of effort.
In this way, you will only need to enter the number of your identity document and you will obtain the corresponding letter instantly. Definitely, This process is the simplest, and perhaps the most recommended, since it facilitates the task by not applying the mathematical formula or the process in Excel.
The letter in the DNI has several important purposes: verify the authenticity of the identification number, prevent errors, facilitate personal identification, prevent identity theft and expedite procedures and procedures.
It is essential to ensure the correct identification of people and provide greater security in administrative and legal procedures.