Browse

UNICODE Function (LibreOffice Calc)

Text Beginner LibreOffice Calc

Learn the UNICODE function in LibreOffice Calc: Returns the numeric code for the first Unicode character in a text string.

The UNICODE function in LibreOffice Calc is used for this task: Returns the numeric code for the first Unicode character in a text string. Find a Unicode character code.

This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.

Syntax and arguments

UNICODE(text)
Argument Required? Meaning
Text Yes This is the text for which the code of the first character is to be found.

Calc formulas normally use semicolons (;) between arguments in common configurations; the displayed separator may depend on settings or locale.

Worked example

=UNICODE("★")

Expected result: 9733.

Why it works: Find a Unicode character code.

How to use it in your own spreadsheet

  1. Identify the cells or inputs that correspond to the sample values above.
  2. Enter the formula in an empty cell, changing the references or literal values to match your sheet.
  3. Compare the output with a manual check on a small known example.
  4. Extend the formula to a larger dataset only after you understand the result.

Common problems and practical checks

  • Check unwanted spaces, character case, and whether the input is stored as text.
  • Character positions and formatting can change the result; test with realistic sample text.
  • A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.

LEFT RIGHT MID LEN TRIM.

Documentation and verification

  • LibreOffice Calc Help
  • The standalone example was calculated using LibreOffice Calc 25.2.3.2 on October 9, 2026 and its computed result matched the expected value. This does not certify every option, version, or other example.