💻 Software

Can you do Regular Expressions in Excel without VBScript?

Fresh7 days ago

Mar 15, 202681662 views

Confidence Score0%

Problem

I'm looking for an Excel function that I can put in a cell to do a regex search of the contents of another cell. Is there anything available to do this? I'd prefer not to have to add VB Script to the spreadsheet for this because I can hard-code a solution faster. It's just that the fastest solution…

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Can you do Regular Expressions in Excel without VBScript?

Low Risk

You can simply add a reference to 'Microsoft VBScript Regular Expressions 5.5' in the VBE to expose the VBScript.dll regex functions to Excel. Writing a simple regex function is then trivial, e.g.

Awaiting Verification

Be the first to verify this fix

Can you do Regular Expressions in Excel without VBScript?

Problem

1 Fix

Fix for: Can you do Regular Expressions in Excel without VBScript?

Environment