Products

CODE function

PRO BASIC

The CODE function in Jspreadsheet Formulas Pro is used to retrieve the numeric code that represents the first character in a text string. This function is particularly useful when you need to perform operations based on the ASCII value of characters. For instance, if the input in CODE is 'A', the function will return 65, because 65 is the ASCII value for the uppercase letter 'A'. This function allows you to gain deeper insights and perform character-based analysis or sorting by retrieving the ASCII/Unicode value of the first character in a string.

Documentation

Returns a numeric code for the first character in a text string.

Category

Text

Syntax

CODE(text)

Parameter Description
text The text string containing the character for which you want the code.

Behavior

The 'CODE' function returns the Unicode value of the first character in the text provided. It expects a string input and will return an error if no input is provided.

  • Empty cells: If the 'CODE' function is applied to an empty cell, it will return an error because no character is available to return a Unicode value.
  • Text: For text, the 'CODE' function will return the Unicode of the first character in the string. If multiple characters are present, only the first one's Unicode value will be returned.
  • Booleans are coerced to text (TRUE → "TRUE"), so CODE(TRUE) will return 84 (for "T").
  • Errors: If the cell to which the 'CODE' function is applied contains an error, the 'CODE' function will also return an error.

Common Errors

Error Description
#VALUE! Occurs if the supplied argument is not a valid text string.

Best practices

  • Always ensure the input to the 'CODE' function is a valid text string. Providing a number, boolean, or error as an input will result in an error.
  • Remember that the 'CODE' function only considers the first character of a text string. If you need to find the code of a character other than the first one, consider using other text functions to manipulate the string first.
  • Be aware that the 'CODE' function returns Unicode values based on the UTF-16 standard. If you're working with characters from other encodings, the returned Unicode value may not be what you expect.
  • Always check for errors in your cells before applying the 'CODE' function to avoid cascading errors.

Usage

A few examples using the CODE function.

CODE("Z") → 90  
CODE("abc") → 97  // only the first character ("a") is evaluated  
CODE(TRUE) → 84   // "T" is the first character of the coerced string "TRUE"  
CODE("") → #VALUE!  // Empty string results in error  

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('ZDdkYzcxMjNlNGU4OWU3NWNhOWFlMDk3ZjkyMWM0ZDA2ZTU3NGJhMWRiYWE5OTBlZjE3NmVlODc2ZGFjYWY2MmM5Y2Y1OWZkZDE2ZTQ3ODBmMmM0ZmI2Yzc5NGExZmEzY2FiZjM4ZjExNzAzYjc5NzQyNWNhNmE0ZjEyYmE5M2UsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Character",
        "ASCII Code"
    ],
    [
        "A",
        "=CODE(A2)"
    ],
    [
        "z",
        "=CODE(A3)"
    ],
    [
        "@",
        "=CODE(A4)"
    ],
    [
        "5",
        "=CODE(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('ZDdkYzcxMjNlNGU4OWU3NWNhOWFlMDk3ZjkyMWM0ZDA2ZTU3NGJhMWRiYWE5OTBlZjE3NmVlODc2ZGFjYWY2MmM5Y2Y1OWZkZDE2ZTQ3ODBmMmM0ZmI2Yzc5NGExZmEzY2FiZjM4ZjExNzAzYjc5NzQyNWNhNmE0ZjEyYmE5M2UsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

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

    // Worksheet data
    const data = [
    [
        "Character",
        "ASCII Code"
    ],
    [
        "A",
        "=CODE(A2)"
    ],
    [
        "z",
        "=CODE(A3)"
    ],
    [
        "@",
        "=CODE(A4)"
    ],
    [
        "5",
        "=CODE(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('ZDdkYzcxMjNlNGU4OWU3NWNhOWFlMDk3ZjkyMWM0ZDA2ZTU3NGJhMWRiYWE5OTBlZjE3NmVlODc2ZGFjYWY2MmM5Y2Y1OWZkZDE2ZTQ3ODBmMmM0ZmI2Yzc5NGExZmEzY2FiZjM4ZjExNzAzYjc5NzQyNWNhNmE0ZjEyYmE5M2UsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

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

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Character",
        "ASCII Code"
    ],
    [
        "A",
        "=CODE(A2)"
    ],
    [
        "z",
        "=CODE(A3)"
    ],
    [
        "@",
        "=CODE(A4)"
    ],
    [
        "5",
        "=CODE(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('ZDdkYzcxMjNlNGU4OWU3NWNhOWFlMDk3ZjkyMWM0ZDA2ZTU3NGJhMWRiYWE5OTBlZjE3NmVlODc2ZGFjYWY2MmM5Y2Y1OWZkZDE2ZTQ3ODBmMmM0ZmI2Yzc5NGExZmEzY2FiZjM4ZjExNzAzYjc5NzQyNWNhNmE0ZjEyYmE5M2UsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01EY3pNekV5TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// 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",
        "ASCII Code"
    ],
    [
        "A",
        "=CODE(A2)"
    ],
    [
        "z",
        "=CODE(A3)"
    ],
    [
        "@",
        "=CODE(A4)"
    ],
    [
        "5",
        "=CODE(A5)"
    ]
]
            }]
        });
    }
}