Google Sheets
UNICODE function in Google Sheets
Returns the decimal Unicode value of the first character of the text.
=UNICODE(text)UNICODE syntax and parameters
One argument, one required.
- textstringRequired
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 Excel
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 Google Sheets gets this done.
- ARABICComputes the value of a Roman numeral.TextExcel
- CHARConvert a number into a character according to the current Unicode table.TextExcel
- CLEANReturns the text with the non-printable ASCII characters removed.TextExcel
- CODEReturns the numeric Unicode map value of the first character in the string provided.TextExcel
- CONCATENATEAppends strings to one another.TextExcel
- DOLLARFormats a number into the locale-specific currency format.TextExcel