The `UNICODE` function in Excel is used to return the numeric Unicode value of the first character in a text string. This function is useful when you want to identify the code number associated with a specific character in the Unicode standard.

Here’s how you can use the `UNICODE` function:

Syntax

=UNICODE(text)

• text: The input text for which you want to find the Unicode value of the first character. The text should be a string or a cell reference containing the character.

Example

Suppose you want to find the Unicode value of the character “A”.

• Direct Input:
• Formula: `=UNICODE(“A”)`
• This will return `65`, which is the Unicode value for the uppercase letter “A”.
• Using a Cell Reference:
• If cell `A1` contains the character “B”, you can use the formula: `=UNICODE(A1)`
• This will return `66`, which is the Unicode value for the uppercase letter “B”.

Tips

• The `UNICODE` function only considers the first character of the provided text string. If the string contains multiple characters or text, it will only evaluate the first one.
• This function is useful for handling specific text data tasks, such as text encoding conversions, and ensuring uniformity in data systems supporting Unicode.

Ensure your version of Excel supports the `UNICODE` function, as it is available in Excel 2013 and later versions.

Follow us on Social Media

facebooklinkedin

Unlock Your Potential

Excel

Access

Power BI

Help us grow the project