Regular Expression Search Formula in Excel - Regex

Add to Favorites
Author: | Edits: don

Part 1 - Regular Expression Match Formula in Excel (No VBA)

Part 2 - Complete Excel Regular Expression Formula System (No VBA)

How to Make a Regular Expression Match or Search in Excel using a single Formula - this formula allows you to decide which characters are allowed, if they can be capital or lower-case, and much more and requires no VBA or Macros!

This tutorial shows you how to make a fully custom regular expression formula in Excel that requires no VBA or macro.

This forms part 1 of a 2 part series on how to make your own custom regex formulas for Excel and this part covers the special regex formula that allows you to check parts of a cell to ensure they contain only characters from an allowed set of characters.

Unfortunately, there is no standard regex function for Excel, so we are forced to create a custom version of it, and, though it lacks the power of those used in standard programming languages, the formulas covered here will allow you to perform some very specific pattern matching and data validation type checks to ensure that cells contain only what they are supposed to contain.

The setup that you will learn here includes more than just a formula, but a way of setting up your data and designing your worsksheet so that it makes it easier for you to develop your own custom regular expression formulas for Excel.

I hope you enjoy this tutorial!

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.