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

Complete system for creating Regular Expression formulas in Excel without VBA or Macros! This tutorial shows you the system for how to make the regular expression formula that will work for any data set or pattern for which you need it.

This tutorial forms Part 2 of the 2 part series for how to create your own custom regex formulas for Excel.

Whereas the previous tutorial focused on the special and complex regex formula that I created especially for this system, this tutorial focuses on the system itself, that allows you to easily create a monster regex formula in Excel - the system works in a step-by-step manner so it is easy to create a monster formula that can match any pattern that you need it to match in Excel.

This tutorial shows you a setup and focuses less on custom formulas; if you want a full deconstruction on the custom regex formula, make sure to check Part 1 of this tutorial series, which is linked to higher up in the description.

I hope you enjoy this tutorial and find it helpful!

#excel #tutorial #howto

[adithmart]

I am new to Excel. I see the power of Excel, on my end, through statistical analyses of machines and or employee capability. You just made my learning curve way faster than normal! Can I use Excel to output a +voltage or a zero voltage from my USB on the laptop?

[darrylmorgan]

Great Tutorial With An Impressive Formula!Glad I Don't Have To Construct One Like That Very Often Ha Ha... Thank You Sir :)

[montmraaa]

This system will never come close to serving in the same was as regular expressions. This method is very complicated and relies heavily upon pre-determined positions of character types. It's a mistake to call this a "Complete" system to replace regular expressions.

[doktorexcel]

Great Tutorial, thank you. I also tried this Version of the number check: AND(ISNUMBER(VALUE(MID(B3, 5, 1))), ISNUMBER(VALUE(MID(B3, 6, 1))), ISNUMBER(VALUE(MID(B3, 7, 1))))

[amitupalkar]

There is an error & can't play the video

[akandemichael]

Hello, your tutorials are educative. Could you share your e-mail so that I can ask you some questions?