Zip and unzip files - Microsoft Support
Locate the zipped folder that you want to unzip (extract) files or folders from. To unzip a single file or folder, open the zipped folder, then drag the file or folder from the zipped folder to a new location.
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.
Extract files or objects from a PowerPoint file
You can extract files and objects, such as videos, photos or documents, from PowerPoint presentations for separate use. The easiest way to do this is to turn the presentation into a "zipped" file.
TEXTAFTER function - Microsoft Support
When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from …
WD: How To Extract Embedded Images from a Word Document
To extract embedded images from a Word document save the document as a web page using the following steps: 1. On the File menu click Save as Web Page 2. In the Save As drop down select …
Copy text from pictures and file printouts using OCR in OneNote
Learn how to use Optical Character Recognition (OCR), a tool that lets you copy text from a picture or file printout and paste it in your notes so you can make changes to the words.
TEXTBEFORE function - Microsoft Support
Returns text that occurs before a given character or string. It is the opposite of the TEXTAFTER function. =TEXTBEFORE (text,delimiter, [instance_num], [match_mode], [match_end], …
LEFT function - Microsoft Support
Specifies the number of characters you want LEFT to extract. Num_chars must be greater than or equal to zero. If num_chars is greater than the length of text, LEFT returns all of text. If num_chars is …
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It …
Export data to Excel - Microsoft Support
Using the Export Wizard, you can export data from an Access database to in a file format that can be read by Excel. This article shows you how to prepare and export your data to Excel, and also gives …
Save embedded media from a presentation (audio or video)
Extract a media file from a presentation: Use the "Save media as" command to save an on-slide audio or video file to your computer so that you can reuse it elsewhere.