REGEXEXTRACT Function - Microsoft Support
Enter one of the following: The simplest pattern is the literal text you want to match. For example to match the text "Match Me", you can use the pattern "Match Me". Symbols called ‘tokens' can be also …
REGEXREPLACE Function - Microsoft Support
Example 1 Use REGEXREPLACE to anonymize phone numbers by replacing their first 3 digits with ***, using pattern
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. The …
Apply or remove cell shading in Excel - Microsoft Support
To use a pattern with two colors, select another color in the Pattern Color box, and then select a pattern style in the Pattern Style box. To use a pattern with special effects, select Fill Effects, and then select …
Add a fill or effect to a shape or text box - Microsoft Support
A fill is a color, pattern, texture, picture, or gradient applied to the interior of a shape. A gradient is a gradual progression of colors and shades, usually from one color to another color, or from one shade …
Add a color or pattern behind a group of objects, an entire page, or ...
To add a color or a pattern behind a group of objects, you draw a shape, such as a rectangle, a circle, or an AutoShape, fill it with a color or pattern, and then move the shape behind the group of objects.
Using Flash Fill in Excel - Microsoft Support
Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two …
Enter a series of numbers, dates, or other items
Excel can continue a series of numbers, text-and-number combinations, or formulas based on a pattern that you establish. For example, you can enter Item1 in a cell, and then fill the cells below or to the …
Add a new fill pattern, line pattern, or line-ends pattern
In the Drawing Explorer window, right-click Fill Patterns, Line Patterns, or Line Ends, and then click New Pattern. Under Details, in the Name box, type a name for the pattern, and then click the pattern type …
Apply shading to alternate rows or columns in a worksheet
Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.
Examples of wildcard characters - Microsoft Support
To locate a specific item when you can't remember exactly how it is spelled, try using a wildcard character in a query. Wildcards are special characters that can stand in for unknown characters in a …