How to extract irregular fields in excel: First open the software and open the [File] function; then click the [Open] function to open the file that needs to extract text; then enter the formula in the extracted text filled cell; Finally, enter and press Enter to complete the text extraction.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to extract irregular fields in excel:
1. First, open our computer, find the software we need to use "Excel2010" on the computer desktop, and click Open the software.
#2. Click the "File" function in the top menu bar of this interface, and then click the "Open" function to open the file we need to extract text from.
3. Enter the formula in the extracted text filled cell. For example: enter the following formula in cell B1: "=LOOKUP(32767,FIND(D$1:D $3,A1),D$1:D$3)".
4. Enter and press Enter to complete the text extraction. Then, slide the mouse and fill the content into other cells when the cursor changes to " ".
Related learning recommendations: excel basic tutorial
The above is the detailed content of How to extract irregular fields in excel. For more information, please follow other related articles on the PHP Chinese website!