ACPD logo

Excel 2025: Regex Functions

(0 reviews)
by Alan Murray

Part of a series on 2025 Excel. Pattern recognition has reached new levels with built-in regex functions, enabling advanced text manipulation, based on text patterns. Discover what you could do to enhance your productivity with REGEXEXTRACT, REGEXREPLACE, and REGEXTEST.

£+vat
1 CPD hours
120 days' access

This course will enable you to

  • Understand the basics of regex and when to use it
  • Pull values based on patterns with REGEXEXTRACT
  • Reformat or clean text with REGEXREPLACE
  • Validate values with REGEXTEST
  • Enhance lookups with regex-powered XLOOKUP and XMATCH formulas
  • About the course

      New built-in regex functions allow you to extract, transform, and validate data with unmatched precision.

      This short course takes a deep dive into Excel's new regex functions – REGEXEXTRACT, REGEXREPLACE, and REGEXTEST. You'll explore what they can do for you and your spreadsheets and also find out how to combine regex with lookup functions like XLOOKUP and XMATCH to match data more flexibly.

    Look inside

    Contents

    How it works

    Author

    Alan Murray

    Alan has over 20 years’ experience as an Excel trainer and loves to help companies improve their business processes and learn how to harness the power of Excel.

    Reviews

    (0 review)
    5
    4
    3
    2
    1
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.
    JS
    Smith J
    19 Nov 2025
    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse sodales consequat enim. Vivamus congue purus vitae erat sollicitudin commodo. Suspendisse ac lorem turpis.

    You might also like

    Take a look at some of our bestselling courses

    alt

    2025 Autumn Budget

    alt

    2025 Winter Update: UK Tax

    alt

    2025 Tax Bulletin: December

    alt

    The Accountant as Company Secretary

    Got a team of 2 or more?

    Develop and retain a talented finance team with our team subscriptions.

    Use ACPD101 for 10% off any purchase.