ASCII code behaviour and special characters in Excel

Haui

Board Regular
Joined
Apr 5, 2009
Messages
199
Hi all, I've read a fair bit about special characters, ASCII code, code/char functions etc. in Excel but still have a couple of understanding questions where I was hoping someone could shed a little light on them or point me to a direction for further reading:

(using the num keypad only):

- In Excel: Why does ALT+32 yield the same result as ALT+032 or ALT+0032 but this is not the case for ALT+160 vs. ALT+0160? (I understand ALT+xxx refers to IBM Code Page 437 whereas ALT+0xxx refers to Windows Code Page 1252 - not sure if there's anything more to this or even what this means/why this was implemented in Excel like this?)

- The mathminus unicode is 8722: why does it produce the correct mathminys symbol in MS Word with ALT+8722 but not in Excel where the same code/key combination produces an up/down-arrow (↕) which is created by the UNICODE charater 8597. (However, =unichar(8722) correctly produces the mathminus in Excel.)

- How can the non-printable characters that the CLEAN-function cannot remove be replicated/inserted in Excel, if possible at all? This includes to my knowledge the UNICODE-Characters U+0000 to U+001F - equivalent to the first 32 ASCII characters ALT+000 to ALT+031 and characters represented by ALT+127/129/141/143/144/157?
E.g. =char(10) or ALT+Enter (if used in-cell) replicates the line feed of ALT+010 / U+000A. I am not aware similar methods exist for any other of these characters (possibly because they are less 'tangible' in Excel word than the line feed, e.g. ALT+127 = DEL (Delete)).

Thanks
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
8,775
Office Version
2007
Platform
Windows
- How can the non-printable characters that the CLEAN-function cannot remove be replicated/inserted in Excel, if possible at all? This includes to my knowledge the UNICODE-Characters U+0000 to U+001F - equivalent to the first 32 ASCII characters ALT+000 to ALT+031 and characters represented by ALT+127/129/141/143/144/157?
E.g. =char(10) or ALT+Enter (if used in-cell) replicates the line feed of ALT+010 / U+000A. I am not aware similar methods exist for any other of these characters (possibly because they are less 'tangible' in Excel word than the line feed, e.g. ALT+127 = DEL (Delete)).

Thanks

Check here some proposals.
https://www.mrexcel.com/forum/excel-questions/1097028-need-help-replacing-invalid-characters-cell.html
 

Forum statistics

Threads
1,081,795
Messages
5,361,333
Members
400,627
Latest member
Mcomeaux

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top