course
Excel Regex Tutorial: Mastering Pattern Matching with Regular Expressions
Discover the power of Regular Expressions (RegEx) for pattern matching in Excel. Our comprehensive guide unveils how to standardize data, extract keywords, and perform advanced text manipulations.
Dec 14, 2023 · 12 min read
Learn Excel Fundamentals
Gain skills to use Excel effectively—no experience required.
Advance Your Career with Excel
Gain the skills to maximize Excel—no experience required.
Topics
Start Your Excel Journey Today!
4 hr
68.7K
course
Data Analysis in Excel
3 hr
50.6K
course
Data Visualization in Excel
3 hr
18.1K
See More
RelatedSee MoreSee More
cheat-sheet
Regular Expressions Cheat Sheet
Regular expressions (regex or regexp) are a pattern of characters that describe an amount of text. Regular expressions are one of the most widely used tools in natural language processing and allow you to supercharge common text data manipulation tasks.
Richie Cotton
tutorial
Python Regular Expression Tutorial
Discover the power of regular expressions with this tutorial. You will work with the re library, deal with pattern matching, learn about greedy and non-greedy matching, and much more!
Sejal Jaiswal
20 min
tutorial
A Guide to R Regular Expressions
Explore regular expressions in R, why they're important, the tools and functions to work with them, common regex patterns, and how to use them.
Elena Kosourova
16 min
tutorial
Data Wrangling with INDEX-MATCH in Spreadsheets
In this tutorial, you will get an overview of how to use the INDEX-MATCH function in spreadsheets.
Francisco Javier Carrera Arias
11 min
tutorial
Using Regular Expressions to Clean Strings
This tutorial takes course material from DataCamp's Cleaning Data in Python course and allows you to clean strings using regular expressions.
Ryan Sheehy
4 min
tutorial
Conditional Formatting in Excel: A Beginner’s Guide
Explore conditional formatting in Excel with simple to advanced examples and their best practices.
Joleen Bothma
7 min