How to Extract Pictures From An Excel File

If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. There's no build-in function to do this in Excel.

 Here are two simple ways to quickly extract pictures from an Excel file.

1.  Change the save as type to *.htm, *.html

Open your Excel file, click File tab, choose Save As, in the Save As window, click the drop-down menu labeled Save as type:, scroll down and choose Web Page (*.htm;*.html), Click Save.

When a web page is saved in a computer two files are actually generated. One is the html file, and another is a folder that contains all the images and other component files that are a part of the web page. For example, an Excel file named Products.xls saved as a web page will generate Products.htm and a folder labeled Products_files. If Products.xlscontained images, these images will now be in the Products.xls_files folder. Now, open Products.xls_files folder, you will sell all the pictures.

2. Change the Excel file extension (only available with .xlsx) as a RAR file 

For example, change Products.xlsx to Products.rar, extract the Products.rar file, you will see 3 folders (_rels, docProps and xl) and 1 xml file ([Content_Types].xml), open xl folder, open media folder, you will sell all the images in the media folder.

How To Extract Formulas From Excel At Once

Sometimes you may need to convert formula to text string in Excel, such as =A1+B1, follow the below mentioned steps for extracting the formulas from Excel at once.

Example

For Example, we need to show the Column C with original formulas but not their calculated results in Column D, see the following screen shot.

Steps

1. select Column C.
2. Under the Data menu tab, in the Data Tools group, click the Text to Columns button.
3. In Convert Text to Columns Wizard window, do the following:
   1. In Convert Text to Columns Wizard - step 1 of 3 window, click Next.
   2. In Convert Text to Columns Wizard - step 2 of 3 window, click Next.
   3. In Convert Text to Columns Wizard - step 3 of 3 window, under Column data format, choose Text, in Destination box, enter a cell reference: D1, or click Collapse Button  to temporarily hide the dialog box, select cell D1 on the worksheet, and then press Expand Button .
   4. click Finish.

Final Results

Video