Excel 2010 - list of characters for CHAR function
Solved
ButteDuLac
Posted messages
534
Status
Member
-
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
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
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
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
To complete Patrice, from 0 to 31, these are not characters as such, but control codes.
eric