Forum Discussion
Solved
Code vs Char Question
Hi. I know how to use Code and Char functions in theory, but not getting the expected results. I am working with filled circles (●) and open circles (○) as follows, where I need to use the Char function with the character number instead of the character itself. Clearly 63 is incorrect in both cases.
Aside from needing the correct number for those two specific characters, how do I get the correct number for any similar situations with other special characters?
| A | B | C | D | E | |
| 1 | ● | Code(a1)= | 63 | Char(c1)= | ? |
| 2 | ○ | Code(a2)= | 63 | Char(c2)= | ? |
CODE and CHAR only work over the ASCII dataset. To extend the coverage to the Unicode dataset use the functions
= UNICODE(symbols) = UNICHAR(unicodes)
CODE and CHAR only work over the ASCII dataset. To extend the coverage to the Unicode dataset use the functions
= UNICODE(symbols) = UNICHAR(unicodes)- Thank you!
