REGEXEXTRACT Function - Microsoft Support
The REGEXEXTRACT function allows you to extract text from a string based on a supplied regular expression. You can extract the first match, all matches or capturing groups from the first match.
REGEXREPLACE Function - Microsoft Support
The REGEXREPLACE function allows you to replace text from a string with another string, based on a supplied regular expression ("regex"). Syntax. The REGEXREPLACE function replaces strings within the provided text that matches the pattern with replacement. The syntax of the REGEXEXTRACT function is:
REGEXTEST Function - Microsoft Support
The REGEXTEST function allows you to check whether any part of supplied text matches a regular expression ("regex"). It will return TRUE if there is a match and FALSE if there is not. Syntax
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Replace values (Power Query) - Microsoft Support
In Power Query, you can replace one value with another value in a selected column. You can replace specific values or the whole value in a cell. Replacing values in a query does not edit the external data source in any way. Replace text values. Replace number, date/time, or logical values. See Also. Power Query for Excel Help.
Filter by using advanced criteria - Microsoft Support
Filter by using advanced criteria. If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog box, click Data > Advanced.
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
REPLACE, REPLACEB functions - Microsoft Support
This article describes the formula syntax and usage of the REPLACE and REPLACEB function in Microsoft Excel. Description. REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
LEFT, LEFTB functions - Microsoft Support
LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. These functions may not be available in all languages.
Get started with Python in Excel - Microsoft Support
To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.
SUBSTITUTE function - Microsoft Support
Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.