Code vs Char Question

[wkrasl]

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)=	?

[#2 · Accepted 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)

[#3]

Thank you!