REGEXEXTRACT returns text matching a regular expression. Start with a narrow, known pattern and keep the original field available for checking exceptions.
Define the exact text to extract
For the text Ticket AB-123 ready, =REGEXEXTRACT(A2,"AB-[0-9]+") extracts AB-123. The example requests a literal prefix followed by one or more ordinary digits.
The function returns the first match, not every matching occurrence in a long note. Decide whether the source is supposed to contain one ID or several before treating that first result as complete.
Understand groups and input types
Capture groups in parentheses can return extracted subparts in separate output columns. Leave room for those results. Without groups, the whole matched portion is returned.
Google Sheets uses RE2 with a documented Unicode character-class limitation. Do not assume a pattern from another regular-expression engine works unchanged. REGEXEXTRACT expects text and returns text, which is appropriate for IDs whose leading zeros must survive.
Review no-match and false-match cases
Test a valid record, a missing ID, an unrelated similar prefix, and a note containing multiple candidate IDs. If no match is an expected state, use a narrowly explained IFNA label after the valid path works.
Do not convert every extracted numeric-looking string to a number automatically. Also avoid a broad pattern that finds an unrelated digit sequence merely to prevent empty results. Keep exceptions visible and compare extracted IDs with the source system before using them to join records, trigger actions, or replace an authoritative identifier column.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.