Function that shows the Unicode code of a character

Does this help?Excel 2000

..I think that is ascii code though, not what you are looking for?

Jubinell said:

Does such function exist in Excel?

Click to expand...

Hi Jubinell

No. But you can use a simple udf to get it:


Assuming the character in A1, use the udf in a cell as:

=CodeUni(a1)

to get the hexadecimal value of the character (the usual value in unicode maps)

or

=CodeUni(a1,False)

to get the decimal value of the character.

If the first parameter of the udf is a string you get the code of its first character.

@taigovinda

Thanks but no this is different. The function that I'm looking for would return some or all of the columns on the right at the following website:

http://unicodelookup.com/#latin/1

@pgc01

Thanks I will try this out.

Sorry, remove the "As Long" from the procedure declaration:

@pgc01

This seems to work flawlessly with one exception. Results starting with 0s were truncated in the output cell. For example the character 'A' returns 41 but its code should have been 0041.

I tried to set the format of the cells as text before using the functions but with that the functions wouldn't evaluate at all.

Any thoughts?

Notice that the "A" character number is 41 hexadecimal or 65 decimal. In maps you get 41 or 0041 or U+0041 or 0x41, but these are the same number with different formats, as you know left zeros in a number have no value.

To get the hexadecimal numbers in the format 0000, try:

I got you.
Thanks!

I'll add also the inverse function so that this thread can be used as reference.

Get the unicode character Γ (capital gamma) given its code we can use:

=CharUni(393)
=CharUni("393")
=CharUni("0393")
=CharUni(915,False)

The second parameter has the value False if we give the code as decimal, True or omitted if the code is hexadecimal.

Notice that if the hexadecimal code has letters the code must be entered as string or you may have a bad surprise.

Ex:

=CharUni(A93)
=CharUni("A93")

The first is the char corresponding to the value in A93, the second the char corresponding to the hexadecimal code "A93"

Hi PGC,

Sorry to open up an old post but I've encountered a problem with Unicode characters again.

I'm looking at the character
<table style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"><tbody><tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; width: 48pt;" height="20" width="64">�</td></tr></tbody></table>(that's an image)
in text, it is
&#55360;&#56738;

Now when i run CodeUni(), I get D840.
Yet when I run CharUni on D840, I get
<table style="border-collapse: collapse; width: 50pt;" border="0" cellpadding="0" cellspacing="0" width="67"><col style="width: 50pt;" width="67"><tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 50pt;" height="20" width="67">�</td> </tr></tbody></table>that's an image
in text, it is:
�

Any idea this is? This is a very rare sub-type of the Japanese radical hito (person). This character usually have 2 forms that are more common:, 人 and 亻. I do not have problems with these two forms.

Thank you once again for any insight you can give.