Quadratic Docs
  • Getting started
  • Examples
  • Open Quadratic
  • Quadratic AI
    • Getting started
    • Generate code
    • Generate data
    • Import PDFs
    • Import images
    • Security
  • Connections
    • SQL - getting started
    • PostgreSQL
    • MySQL
    • MS SQL Server
    • Parametrize queries
    • SQL AI assistant
    • Security
    • API requests
    • Request a connection
  • Python
    • Getting started
    • Reference cells
    • Return data to the sheet
    • Packages
    • Make an API request
    • Clean data
    • Charts/visualizations
    • Manipulate data
  • Javascript
    • Getting started
    • Reference cells
    • Return data to the sheet
    • API Requests
    • Charts/visualizations
    • Packages
  • Formulas
    • Getting started
    • AI assistant
    • Reference cells
    • Functions and operators
    • Arrays
    • Criteria
    • Wildcards
  • Spreadsheet
    • Navigating
    • Files
    • Shortcuts
    • Insert/delete rows and columns
    • Data validation
    • Present & share
    • Date-time formatting
    • Browser compatibility
  • Teams
    • Manage your team
    • Private files
    • Collaboration
    • Embedded sheets
  • Import data
    • SQL connections
    • API requests
    • Drag and drop .CSV
    • Drag and drop .Parquet
    • Import Excel files
  • Self hosting
    • Getting started
    • Docker
    • AWS
    • Azure
    • Google Cloud Platform
    • Bring your own AI
    • Other hosting
  • Quadratic for Education
    • Overview
    • Enrolling in the education plan
    • Teachers
    • Students
    • Researchers
    • Education FAQ
  • Company
    • About
    • Quadratic is source available
    • Brand assets
  • GitHub
  • Blog
  • Twitter
  • Discord
Powered by GitBook
On this page

Was this helpful?

  1. Formulas

Wildcards

Using Wildcards in formulas to match certain cells.

PreviousCriteriaNextNavigating

Last updated 1 month ago

Was this helpful?

Wildcard patterns can be used with several formula functions, including MATCH (with a match_modeof 0) and XLOOKUP(with match_mode of 2). They can also be used in with any equality-based comparison (=, ==, <>, !=, or no operator)

In wildcards, the special symbols ? and * can be used to match certain text patterns: ? matches any single character and * matches any sequence of zero or more characters. For example, DEFEN?E matches the strings "defence" and "defense", but not "defenestrate". *ATE matches the strings "ate", "inflate", and "late", but not "wait". Multiple ? and * are also allowed.

To match a literal ? or *, prefix it with a tilde ~: for example, COUNTIF(A1:A10, "HELLO~?") matches only the string "Hello?" (and uppercase/lowercase variants).

To match a literal tilde ~ in a string with ? or *, replace it with a double tilde ~~. For example, COUNTIF(A1:A10, "HELLO ~~?") matches the strings "hello ~Q", "hello ~R", etc. If the string does not contain any ? or *, then tildes do not need to be escaped.

criteria