Table of Contents
The UNICHAR function in Google Sheets allows users to input a Unicode value and convert it into its corresponding character. This function can be used to display special characters, symbols, and emojis that are not readily available on the keyboard. To use the UNICHAR function, simply enter the Unicode value within the parentheses and the desired character will be displayed in the cell. This function is useful for creating visually appealing and unique spreadsheets, as well as for data entry in multiple languages.
UNICHAR function
Returns the Unicode character for a number. This method supports returning characters in both the UTF-8 and UTF-16 character set.
Parts of a UNICHAR function
UNICHAR(number)
| Part | Description |
number | Required. The number to convert into a Unicode character. The number should be greater than 0. |
Sample formulas
Example 1: UNICHAR(68) returns D
Example 2: UNICHAR(307) returns u0133, which may appear as ij
Notes
- If number is 0, the method returns a #VALUE error.
- If the number does not have a Unicode character, the method returns a #VALUE error.
- It is possible that the method’s output changes overtime as the Unicode character set is refined.
Examples
Result for =UNICHAR(68)
| A | B | |
| 1 | D | |
| 2 |
Result for =UNICHAR(307)
| A | B | |
| 1 | ij | |
| 2 |
Related functions
- UNICODE: The
UNICODEfunction returns the decimal Unicode value of the first character of the text.
Cite this article
stats writer (2024). How can I use the UNICHAR function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-unichar-function-in-google-sheets/
stats writer. "How can I use the UNICHAR function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-unichar-function-in-google-sheets/.
stats writer. "How can I use the UNICHAR function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-unichar-function-in-google-sheets/.
stats writer (2024) 'How can I use the UNICHAR function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-unichar-function-in-google-sheets/.
[1] stats writer, "How can I use the UNICHAR function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the UNICHAR function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.