Excel tutorials

Sometimes when we create formulas or calculations we need to take into account ASCII-characters. So, in this part we are going to look at how we can print all the ASCII-characters.

In column A – enter the digits 0 to 255. These represent all the ASCII-codes.

To output a ASCII-character in EXCEL, we can use the =CHAR(number)

If we enter =CHAR(64) – we will get the @-symbol.

To get the presentation as in Column C above – enter the following formula and drag it down to the end:

=”THIS IS THE SYMBOL OF ASCII CHARACTER “&A3&”: “&CHAR(A3)