Table of Contents
The UNICODE function in Google Sheets allows users to convert text into its corresponding numeric code. This function is useful for tasks such as sorting and comparing text values. To use the UNICODE function, simply enter the text you want to convert as the function’s argument. The resulting value will be the numeric code for the text entered. This feature is particularly useful for organizing and analyzing large amounts of textual data. By utilizing the UNICODE function, users can efficiently convert text into a standardized numerical format for easier data manipulation.
UNICODE function
The UNICODE function returns the decimal Unicode value of the first character of the text.
Parts of a UNICODE function
UNICODE(text)
| Part | Description |
|---|---|
| text | The string containing the character to be evaluated. |
Sample formulas
UNICODE(“A”)
UNICODE(123)
UNICODE(😀😀😄)
Notes
The UNICODE function will only work properly if the input string is not empty and the first character has a Unicode representation.
Numbers may be passed directly into the UNICODE function and will be parsed as a string.
Examples
UNICODE : General Usage
| Â | A | B |
|---|---|---|
| 1 | Result | Formula |
| 2 | 65 | =UNICODE(“Alphabet”) |
| 3 | 49 | =UNICODE(123) |
| 4 | 128512 | =UNICODE(😀😀😄) |
Related functions
CHAR: Convert a number into a character according to the current Unicode table.
CODE: Returns the numeric Unicode map value of the first character in the string provided.
Cite this article
stats writer (2024). How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-unicode-function-in-google-sheets-to-convert-text-to-its-corresponding-numeric-code/
stats writer. "How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-unicode-function-in-google-sheets-to-convert-text-to-its-corresponding-numeric-code/.
stats writer. "How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-unicode-function-in-google-sheets-to-convert-text-to-its-corresponding-numeric-code/.
stats writer (2024) 'How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-unicode-function-in-google-sheets-to-convert-text-to-its-corresponding-numeric-code/.
[1] stats writer, "How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the UNICODE function in Google Sheets to convert text to its corresponding numeric code?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.