SOLVED

Code vs Char Question

New 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?

 

 ABCDE
1Code(a1)=63Char(c1)=?
2Code(a2)=63Char(c2)=?

 

2 Replies
best response confirmed by wkrasl (New Contributor)
Solution

@wkrasl 

CODE and CHAR only work over the ASCII dataset.  To extend the coverage to the Unicode dataset use the functions

= UNICODE(symbols)

= UNICHAR(unicodes)

 

image.png

Thank you!