Code vs Char Question

Copper Contributor

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?




2 Replies
best response confirmed by wkrasl (Copper Contributor)


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!