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.

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.

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.

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 …

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.

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 …

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

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.

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 …

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 …

To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu. There are two commonly used text file formats: Delimited text files (.txt), in which …