Do not standardize Word document to Excel format

Excel's powerful computing, management, and analysis capabilities reduce the number of complex repetitive computations. But after investigation, most of the people who use Excel only use 20% of the features in Excel, and 80% of the features have not been applied, which shows that Excel's function has not been deeply applied.

Excel office Automation books are more. However, the discussion about using Microsoft Office to improve productivity is not limited to books and online tutorials.

In practical work, Xinhua Bookstore's website often encountered a variety of non-standard large data processing, the final need is standardized Excel format, the general bar code, the title, author, publishing house and other standard fields. We are going to do a little practice with the example of the website work in the shopping bookstore of Guangzhou.

examples of data processing: The following is a Word document called "100 candidate books," which we need to quickly sort the titles, authors, and publishers into Excel format .

Original:

The style after finishing:

　　Processing Method :

1. Copy the contents of the Word document, in the A2 cell of Excel, press the right key-paste selectively-text

2. Enter text "content" in cell A1, B1 enter "word count"

3. In cell B2, enter the formula =len (A2) and drag the formula to the bottom

4. Select AB column, data-Filter-auto Filter

------------the following start to extract the title -------------

5. Using a custom filter in column A, select include: "," (note: the title is preceded by a, number, so that this is the signature as a filter criteria)

6. Use a custom filter in column B and select a row greater than 20

7. At this point, we see that the title has been all screened out.

Similarly, the author, publishers can also be based on their own signature and length of words, be quickly screened out!

　　Knowledge points :

1. Special paste: selective pasting

2. Common function: Use Len function to count words

3. One of the important ways of data collation: automatic screening

4. Focus of complex data filtering: Using signature

This article original: Xinhua bookstore http://www.gg1994.com Reprint Please specify the source!

        Note : more Wonderful tutorials please focus on the Triple computer Tutorials section, triple Computer office group: 189034526 Welcome to join