You can extract the first match, all matches or capturing groups from the first match. Syntax The REGEXEXTRACT function extracts strings within the provided text that matches the 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 …

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 …

Here’s how to add a line, pattern, or custom border to a text box, picture, and other objects in Word, PowerPoint, or Excel for Mac. Note: If you didn't add the border to the shape, text box, …

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 …

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 …

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, …

You can use the Like operator to find values in a field that match the pattern you specify. For pattern, you can specify the complete value (for example, Like “Smith”), or you can use …

This article explains how to create a custom fill pattern by using a bitmap image in Microsoft Office Visio. The custom fill pattern can then be applied to shapes in a Visio drawing.

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 …

Example 1 Use REGEXREPLACE to anonymize phone numbers by replacing their first 3 digits with ***, using pattern