Products

UNICODE function

PRO BASIC

The UNICODE function in Jspreadsheet Formulas Pro is a tool that gives you the Unicode value of the initial character in any text string. Unicode is a universal standard that assigns a unique numeric value to each character used in digital text, including letters, numbers, symbols and emojis. With the UNICODE function, you can input a string of text and it will return the numeric Unicode value of the first character in that string. This can be particularly useful for various data analysis and manipulation tasks.

Documentation

Returns the Unicode value of the first character in a text string.

Category

Text

Syntax

UNICODE(text)

Parameter Description
text The text string containing the character for which you want to find the Unicode value. If the text string contains multiple characters, only the first character is used.

Behavior

The UNICODE function returns the Unicode value of the first character of the text provided. Here are some behaviors to note:

  • If the cell referenced is empty, the function returns #VALUE! error.
  • If the cell contains a string of text, the function will only consider the first character of the string.
  • If the cell contains a boolean value (TRUE or FALSE), the function will return #VALUE! error as it does not consider boolean values as text.
  • If the cell contains a numerical value, the function will return the Unicode value of the number's character representation.
  • If the function encounters an error, it will return the respective error message.

Common Errors

Error Description
#VALUE! This error is returned when the referenced cell have a invalid parameter. The UNICODE function requires a text value to return the correct Unicode value.
#N/A Returned when no input is provided (empty cell).

Best practices

  • Always ensure that the cell referenced by the UNICODE function contains text. If the cell is empty or contains a boolean value, the function will return an error.
  • The UNICODE function only considers the first character of the text. If you want to get Unicode values for each character in the text, use a separate function for each character.
  • Be aware that the UNICODE function will treat numerical values as their character representation. If you want to get the Unicode value of a number as a character, convert the number to text first.
  • Always check for correct cell references to avoid #REF! errors.

Usage

A few examples using the UNICODE function.

UNICODE("A") returns 65  
UNICODE("€") returns 8364  

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('M2QzNjFiNWQ1NTQ1Nzk3MDg3OWFmNzlmNmVjNTAzMjYxNDljMTQyYTQ5MGIxZTNkNDA1NjEzZDIyZGNkZWJkN2UxMGQzN2IyMTY0NzBhNTk1ZmU5ZDdiN2JhYjIyMWJiMGI2NDg5ODVhYTczOTA0YWQwNDgyNDEwMzc1YTBkYzksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOVEl3TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Character",
        "Unicode Value"
    ],
    [
        "A",
        "=UNICODE(A2)"
    ],
    [
        "\u20ac",
        "=UNICODE(A3)"
    ],
    [
        "\u4e2d",
        "=UNICODE(A4)"
    ],
    [
        "@",
        "=UNICODE(A5)"
    ]
]
  }]
});
</script>
</html>
import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('M2QzNjFiNWQ1NTQ1Nzk3MDg3OWFmNzlmNmVjNTAzMjYxNDljMTQyYTQ5MGIxZTNkNDA1NjEzZDIyZGNkZWJkN2UxMGQzN2IyMTY0NzBhNTk1ZmU5ZDdiN2JhYjIyMWJiMGI2NDg5ODVhYTczOTA0YWQwNDgyNDEwMzc1YTBkYzksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOVEl3TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Character",
        "Unicode Value"
    ],
    [
        "A",
        "=UNICODE(A2)"
    ],
    [
        "\u20ac",
        "=UNICODE(A3)"
    ],
    [
        "\u4e2d",
        "=UNICODE(A4)"
    ],
    [
        "@",
        "=UNICODE(A5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}
<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('M2QzNjFiNWQ1NTQ1Nzk3MDg3OWFmNzlmNmVjNTAzMjYxNDljMTQyYTQ5MGIxZTNkNDA1NjEzZDIyZGNkZWJkN2UxMGQzN2IyMTY0NzBhNTk1ZmU5ZDdiN2JhYjIyMWJiMGI2NDg5ODVhYTczOTA0YWQwNDgyNDEwMzc1YTBkYzksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOVEl3TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Character",
        "Unicode Value"
    ],
    [
        "A",
        "=UNICODE(A2)"
    ],
    [
        "\u20ac",
        "=UNICODE(A3)"
    ],
    [
        "\u4e2d",
        "=UNICODE(A4)"
    ],
    [
        "@",
        "=UNICODE(A5)"
    ]
]

        return {
            data
        };
    }
}
</script>
import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('M2QzNjFiNWQ1NTQ1Nzk3MDg3OWFmNzlmNmVjNTAzMjYxNDljMTQyYTQ5MGIxZTNkNDA1NjEzZDIyZGNkZWJkN2UxMGQzN2IyMTY0NzBhNTk1ZmU5ZDdiN2JhYjIyMWJiMGI2NDg5ODVhYTczOTA0YWQwNDgyNDEwMzc1YTBkYzksZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXdOVEl3TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Character",
        "Unicode Value"
    ],
    [
        "A",
        "=UNICODE(A2)"
    ],
    [
        "\u20ac",
        "=UNICODE(A3)"
    ],
    [
        "\u4e2d",
        "=UNICODE(A4)"
    ],
    [
        "@",
        "=UNICODE(A5)"
    ]
]
            }]
        });
    }
}