Cellgrids Cellgrids
Home › Excel formulas › Text › UNICHAR

UNICHAR Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

UNICHAR is an Excel Text function. Returns the Unicode character for a given number.

UNICHAR syntax

=UNICHAR(number)

Arguments

When to use UNICHAR

UNICHAR is used to clean up and reshape text data pulled from other systems before reporting on it.

Practice UNICHAR online, free

Open the live Excel-style spreadsheet and try UNICHAR yourself. No Excel install or sign-up needed to start.

Practice UNICHAR now →

More Text functions

Frequently asked questions

What does the UNICHAR function do in Excel?

Returns the Unicode character for a given number.

What is the syntax of UNICHAR in Excel?

The syntax is =UNICHAR(number). number: A number to use in the calculation.

Where can I practice UNICHAR online for free?

Open the free live spreadsheet on Cellgrids and try UNICHAR yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts