Administration and Executive AssistantTier 430 minintermediate

REGEXEXTRACT for Pattern-Based Extraction

Pull a code or reference number out of free text wherever it happens to fall.

What you will learn

• Write a simple regular expression pattern to match a known text shape
• Use REGEXEXTRACT to pull the first match out of a longer string
• Explain why a fixed-position extraction (MID/LEFT) breaks when the surrounding text varies

Excel skills

REGEXEXTRACT · Pattern Matching

The task

Every note on the Notes tab mentions an invoice number somewhere in the sentence - but not always in the same place. Pull just the invoice number (the "INV-" followed by digits) out of each one into column B.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free