View original (French)

Excel 2010 - list of characters for CHAR function

Solved
ButteDuLac Posted messages 534 Status Member -  
ButteDuLac Posted messages 534 Status Member -
Hello,

I made a list of characters for the CAR function.

From 33 to 255, everything is fine. And I know that CAR(10) is a line break.

I also believe that CAR(2) is a space...

Some characters seem to change depending on the font (e.g. CAR(12)), but not all of them...

How can I know what characters 1 to 32 (except for 10) represent? Either we see a (seemingly) empty cell, or we see a square or rectangle (maybe a font issue??? (But I tried several fonts, including Windings, Webdings, Symbol... apart from one font, 8514oem, which I didn't even know existed on my computer!)

Basically, I would like to know which ones can be useful with a standard font (e.g. Calibri, Arial, etc.) in a cell, for example, 2 and 10 can be useful...

Thank you!

Configuration: Windows / Chrome 49.0.2623.112

1 answer

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 785
     
    Hello,

    the space is 32!
    among the most useful:
    7 = Bell (ping)
    8 = Backspace
    11 = Tab (horizontal tabulation)
    10 = Line Feed
    12 = Form Feed
    13 = Carriage return
    27 = Escape

    More info here:
    http://www.table-ascii.com/

    --
    Best regards
    Patrice
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      To complete Patrice, from 0 to 31, these are not characters as such, but control codes.
      eric
      0
    2. ButteDuLac Posted messages 534 Status Member 41
       
      Thank you! And thank you for the ASCII table link, very useful!
      0