Formulas > =UNICODE()
How To Use UNICODE() Function in Google Sheets
Description
How To Actually Use UNICODE() in Sheets
UNICODE(text)
Try UNICODE yourself
In cell B1, use the UNICODE formula to find the Unicode value of the first character in cell A1. The result should be a number representing the Unicode value.
Hints (2)
-
Remember to reference the correct cell for the text.
-
The UNICODE function only looks at the first character.
Related formulas
UNICODE works like CODE in Google Sheets. It returns the numeric value of the first character in a string.
Browse all characters
Open the Google Sheets character table to look up Unicode values visually and copy =CHAR(n) formulas.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the UNICODE() formula:
Generate a UNICODE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses UNICODE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a UNICODE() formula