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
(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
