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)"
]
]
}]
});
}
}