UNICHAR

Text Functions

(4.7/5)

Returns the Unicode character that is referenced by the given numeric value. Supports full Unicode character set (beyond ASCII). Essential for working with international characters, emojis, and extended character sets in Excel.

Interactive Formula Tester

Unicode Code:

Formula:

=UNICHAR("65")

Complete Theory & Understanding

Master the fundamentals of Excel UNICHAR function

Core Concept

The UNICHAR function converts Unicode character codes (1-1114111) to their corresponding characters. It extends beyond CHAR function by supporting the full Unicode character set, including emojis, international characters, mathematical symbols, and special characters. Essential for modern text processing and internationalization.

Why Use UNICHAR?

Generate emojis from Unicode codes
Work with international characters
Generate mathematical and special symbols
Map Unicode codes to characters

Key Characteristics

Full Unicode Support

Supports Unicode range 1-1114111

UNICHAR(128512) returns 😀

Emoji Support

Can generate emojis and symbols

UNICHAR(128512) = 😀

International Characters

Supports all international characters

UNICHAR(20013) = 中

Extended Range

Beyond ASCII range of CHAR

UNICHAR supports 1-1114111 vs CHAR 1-255

Function Anatomy

=UNICHAR(parameters...)

Required

Parameters:

Function-specific parameters

Returns

Return Value:

Function-specific return type

Primary Use Cases

Emoji Generation

Generate emojis from Unicode codes

International Text

Work with international characters

Special Symbols

Generate mathematical and special symbols

Character Mapping

Map Unicode codes to characters

Theory Summary

Precise

Exact matching required

Position-Based

Returns numeric position

Error-Safe

Handles missing text gracefully

Syntax & Parameters

=UNICHAR(number)

Required

number:

The Unicode number of the character. Must be between 1 and 1114111.

Returns

Return Value:

Unicode character

Description: Returns the Unicode character referenced by the numeric value (supports full Unicode range)

Interactive Examples

Basic Unicode Character

Convert Unicode code to character

Input Text:

"65"

Formula:

=UNICHAR(65)

Result:

Unicode 65 corresponds to uppercase letter 'A' (same as ASCII)

VBA Implementation & Automation

Basic UNICHAR in VBA

Simple VBA implementation of UNICHAR function

' Basic UNICHAR in VBA
Range("B1").Value = Application.WorksheetFunction.Unichar(65)
' Returns: "A"

' Using VBA Unichar function
Dim unicodeCode As Long
unicodeCode = 128512
Range("B2").Value = Application.WorksheetFunction.Unichar(unicodeCode)
' Returns: 😀

' Generate emojis
Sub GenerateEmojis()
    Range("A1").Value = Application.WorksheetFunction.Unichar(128512) ' 😀
    Range("A2").Value = Application.WorksheetFunction.Unichar(128513) ' 😁
    Range("A3").Value = Application.WorksheetFunction.Unichar(128514) ' 😂
End Sub

' Generate international characters
Sub GenerateInternationalChars()
    Range("A1").Value = Application.WorksheetFunction.Unichar(8364) ' €
    Range("A2").Value = Application.WorksheetFunction.Unichar(165) ' ¥
    Range("A3").Value = Application.WorksheetFunction.Unichar(163) ' £
End Sub

Advanced Unicode Character Generation

Generate ranges of Unicode characters

' Function to get Unicode character safely
Function GetUnichar(code As Long) As String
    On Error Resume Next
    If code >= 1 And code <= 1114111 Then
        GetUnichar = Application.WorksheetFunction.Unichar(code)
    Else
        GetUnichar = "#VALUE!"
    End If
    On Error GoTo 0
End Function

' Generate emoji range
Sub GenerateEmojiRange()
    Dim i As Long
    Dim startCode As Long
    Dim endCode As Long
    startCode = 128512 ' First emoji
    endCode = 128590 ' Last emoji in common range
    
    Dim row As Integer
    row = 1
    For i = startCode To endCode
        Range("A" & row).Value = Application.WorksheetFunction.Unichar(i)
        row = row + 1
    Next i
End Sub

' Convert Unicode code list to characters
Sub ConvertUnicodeList()
    Dim codes() As Variant
    codes = Array(65, 66, 67, 8364, 128512)
    Dim i As Integer
    For i = 0 To UBound(codes)
        Range("A" & (i + 1)).Value = Application.WorksheetFunction.Unichar(codes(i))
    Next i
End Sub