UNICHAR

UNICHAR(number)

Returns the character with the corresponding UNICODE character.

number

The number specifying which character you want between 1 and 65535.

REMARKS

* This function returns the same characters as the CHAR function for numbers 1 to 128.
* This function can be used with other functions to help remove unwanted characters.
* If "number" < 1, then #VALUE! is returned.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the UNICODE function to return the UNICODE number for the first character in a text string.
* You can use the CODE function to return the ANSI/ASCII number for the first character in a text string.
* You can use the CHAR function to return the character with the corrresponding ANSI/ASCII character.
* For more information about the different character sets refer to the Character Codes page.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=UNICHAR(65) = A
2	=UNICHAR(66) = B
3	=UNICHAR(67) = C
4	=UNICHAR(97) = a
5	=UNICHAR(98) = b
6	=UNICHAR(128) = ?
7	=UNICHAR(130) = ?
8	=UNICHAR(256) = A
9	=UNICHAR(257) = a
10	=UNICHAR(1000) = ?
11	=UNICHAR(10000) = ?
12	=UNICHAR(65000) = #N/A
13	=UNICHAR(0) = #VALUE!