FG
💻 Software

Convert Unicode code point to corresponding character in Excel spreadsheet

Fresh5 days ago
Mar 15, 202662023 views
Confidence Score0%
0%

Problem

I use the 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.

Error Output

CHAR()

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Convert Unicode code point to corresponding character in Excel spreadsheet

Low Risk

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 If …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment