Excel – Convert Unicode code point to corresponding character in Excel spreadsheet

hebrewmicrosoft excelunicode

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:

Function Unicode(val As Long)
   Unicode = ChrW(val)
End Function

And then you can call this from your worksheet using =Unicode(A1)

Result of the user defined function

If your Excel has a font that is able to display your character then you will see it.

(if your numbers are in hex):

Function Unicode(val As String)
   Unicode = ChrW("&H" & val)
End Function
Related Question