Products

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 returns FALSE.
  • Text: If the cell contains any text, ISTEXT returns TRUE.
  • Numbers: If the cell contains just a number, ISTEXT returns FALSE. However, if a number is written as text (for example, '123' instead of 123), ISTEXT returns TRUE.
  • Booleans: The ISTEXT function returns FALSE for boolean values (TRUE or FALSE).
  • 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 return TRUE for numbers that are written as text. If you need to check if a cell contains a number, use the ISNUMBER function instead.
  • Remember that ISTEXT will return FALSE 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)"
    ]
]
            }]
        });
    }
}