I use the CHAR()
function to convert an extended ASCII value into a character. What do I use to convert a Unicode code point into a character?
I'm building a Hebrew conversion chart. For example, code point 1489 ( U+05D1 ) is the letter "Bet". I have 1489 in column A, and want to show a Bet in column B.
Best Answer
I think you have to do your own function, VBA has a function to get the character from a code, but I don't know a worksheet function. So, just put in a module of your Excel file this function:
And then you can call this from your worksheet using
=Unicode(A1)
If your Excel has a font that is able to display your character then you will see it.
(if your numbers are in hex):