ExcelExcel 2013+
UNICODE function in Excel
Returns the number (code point) that corresponds to the first character of the text
=UNICODE(text)UNICODE syntax and parameters
One argument, one required.
- textstringRequired
Text is the character for which you want the Unicode value.
UNICODE examples
Formulas you'll actually reuse.
The code point of the euro sign:
=UNICODE("€")Result
8364Flag entries that start with a non-ASCII character:
=UNICODE(LEFT(A2, 1)) > 127Result
TRUE
UNICODE in Google Sheets
Same name — your formula ports as-is.
Try UNICODE in the playground
Edit the example — nothing to install.
Preloaded with the UNICODE formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ARRAYTOTEXTReturns an array of text values from any specified rangeTextNo Google Sheets equivalent
- CHARReturns the character specified by the code numberTextGoogle Sheets
- CLEANRemoves all nonprintable characters from textTextGoogle Sheets
- CODEReturns a numeric code for the first character in a text stringTextGoogle Sheets
- CONCATCombines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.TextGoogle Sheets
- CONCATENATEJoins several text items into one text itemTextGoogle Sheets