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


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)