Creating an Excel spreadsheet to do the conversion of letters to hexadecimal format.
By following 11 basic steps, you can easily and quickly convert letters to hexadecimal format. Once these steps are complete, you just enter the word that you want converted into cell A1 and read the results in column C8.
Steps to do this conversion:
1) Open a new Excel spreadsheet.
2) Create a single cell from A1 to J1. In this cell, you will be writing the text that you want converted to hex numbers.
3) In the cells A2 to U2, write the numbers from 1 to 21. Each cell will only have one number. These cells will be used by Excel to do the conversion.
4) In the cell A3, write the formula = MID ($A$1,A2,1). Drag this formula from A3 to U3. This formula will "break" apart the word written in A1 into individual letters.
5) In the cell A5, write the formula =code(A3). Drag this formula from A5 to U5. This step will convert the individual letters into binary format.
6) In the cell A6, write the formula =dec2hex(A5,2). Drag this formula from A6 to U6. This step will take the binary format of the letters and convert the letters into hexadecimal format.
7) In the cell A8, write the formula =char(E8). Drag this formula from A8 to A40. This step will put the individual letters of the text that you wrote in a column.
8) In the cell C8, write the formula =offset($A$6, 0, J7). Drag this formula from C8 to C40. This step will put the hexadecimal code of each letter in a column.
9) In the cell E8, write the formula = hex2dec(C8). Drag this formula from E8 to E40. This step will put the binary code of each number in a column.
10) Write the number 1 in cell J8. Increment this number by one from cell J8 to J40. This column will be used as a quick reference to see the address of each hexadecimal number.
11) Save this Excel file.