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 2023 · 12 min read
Topics
Start Your Excel Journey Today!
4 hours
46.4K
course
Data Analysis in Excel
3 hours
35K
course
Data Visualization in Excel
3 hours
13.2K
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
Data Wrangling with VLOOKUP in Spreadsheets
In this tutorial, you will get an overview of how to use the VLOOKUP function and also a basic explanation of INDEX-MATCH.
Francisco Javier Carrera Arias
11 min