ISTEXT function
PRO
BASIC
The ISTEXT
function in Jspreadsheet Formulas Pro is a simple tool that helps you determine if a certain value is text or not. When you use this function, it will assess the value you've inputted and return TRUE if it's text. Conversely, if the value is not text, such as a number or date, it will return FALSE. This can be helpful when you're sorting data and need to differentiate between text and other types of values.
Documentation
Checks if a given value is text and returns TRUE if the value is text, and FALSE otherwise.
Category
Information
Syntax
ISTEXT(value)
Parameter | Description |
---|---|
value |
The value that you want to test. |
Behavior
The ISTEXT
function software is used to check if a cell contains text. This function returns TRUE
if the cell contains text and FALSE
if not. Here is how it handles different types of data:
- Empty Cells: If the cell is empty,
ISTEXT
returnsFALSE
. - Text: If the cell contains any text,
ISTEXT
returnsTRUE
. - Numbers: If the cell contains just a number,
ISTEXT
returnsFALSE
. However, if a number is written as text (for example, '123' instead of 123),ISTEXT
returnsTRUE
. - Booleans: The
ISTEXT
function returnsFALSE
for boolean values (TRUE
orFALSE
). - Errors: If the cell contains an error,
ISTEXT
will return that same error instead of TRUE or FALSE.
Common Errors
Error | Description |
---|---|
#VALUE! | Occurs when the provided argument is of an invalid type or contains an unsupported structure. |
#REF! | If the cell reference is invalid, a #REF! error is returned. This typically happens when a referenced cell does not exist. |
Best practices
- Always ensure that the cell reference provided to the
ISTEXT
function is valid. An invalid or incorrect cell reference will result in an error.- Use the
ISTEXT
function to validate input data. It can be used to ensure that a cell contains text before performing operations that require text input.- Keep in mind that
ISTEXT
will returnTRUE
for numbers that are written as text. If you need to check if a cell contains a number, use theISNUMBER
function instead.- Remember that
ISTEXT
will returnFALSE
for boolean values and empty cells. If you need to include these in your condition, consider using a different function or adding additional logic to your formula.
Usage
A few examples using the ISTEXT function.
ISTEXT("banana") returns TRUE because "banana" is a text value
ISTEXT(123) returns FALSE because 123 is not a text value
ISTEXT(A1) returns TRUE if cell A1 contains a text value, and FALSE otherwise.
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('MTM3NThkYzY5YjRmZjljMzJlOTkyYWIyOWEzMjBkNGFjNzkzNTIzYjk1ZWJkZGNmNzc0ZmVlNDMxMjlkOWE2ZmYxNTc2ZDBlMzI5YjI5Y2QxZWNiMGZmYmY3MTAwNjM4ODkzZjMwNTc0ZTU3OTE1OWFjNzg2NTUwMWY5Y2U4MWUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhORFEwTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"Product",
"Price",
"Is Text?"
],
[
"Apple",
1.99,
"=ISTEXT(A2)"
],
[
123,
"Free",
"=ISTEXT(B3)"
],
[
"Orange",
2.5,
"=ISTEXT(A4)"
]
]
}]
});
</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('MTM3NThkYzY5YjRmZjljMzJlOTkyYWIyOWEzMjBkNGFjNzkzNTIzYjk1ZWJkZGNmNzc0ZmVlNDMxMjlkOWE2ZmYxNTc2ZDBlMzI5YjI5Y2QxZWNiMGZmYmY3MTAwNjM4ODkzZjMwNTc0ZTU3OTE1OWFjNzg2NTUwMWY5Y2U4MWUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhORFEwTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"Product",
"Price",
"Is Text?"
],
[
"Apple",
1.99,
"=ISTEXT(A2)"
],
[
123,
"Free",
"=ISTEXT(B3)"
],
[
"Orange",
2.5,
"=ISTEXT(A4)"
]
];
// 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('MTM3NThkYzY5YjRmZjljMzJlOTkyYWIyOWEzMjBkNGFjNzkzNTIzYjk1ZWJkZGNmNzc0ZmVlNDMxMjlkOWE2ZmYxNTc2ZDBlMzI5YjI5Y2QxZWNiMGZmYmY3MTAwNjM4ODkzZjMwNTc0ZTU3OTE1OWFjNzg2NTUwMWY5Y2U4MWUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhORFEwTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"Product",
"Price",
"Is Text?"
],
[
"Apple",
1.99,
"=ISTEXT(A2)"
],
[
123,
"Free",
"=ISTEXT(B3)"
],
[
"Orange",
2.5,
"=ISTEXT(A4)"
]
]
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('MTM3NThkYzY5YjRmZjljMzJlOTkyYWIyOWEzMjBkNGFjNzkzNTIzYjk1ZWJkZGNmNzc0ZmVlNDMxMjlkOWE2ZmYxNTc2ZDBlMzI5YjI5Y2QxZWNiMGZmYmY3MTAwNjM4ODkzZjMwNTc0ZTU3OTE1OWFjNzg2NTUwMWY5Y2U4MWUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhORFEwTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// 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: [
[
"Product",
"Price",
"Is Text?"
],
[
"Apple",
1.99,
"=ISTEXT(A2)"
],
[
123,
"Free",
"=ISTEXT(B3)"
],
[
"Orange",
2.5,
"=ISTEXT(A4)"
]
]
}]
});
}
}