How to extract rows containing keywords in excel?

Solution: 1. Open the excel table and select the data column cell area; 2. Click "Statistics and Analysis" in the square grid (plug-in); 3. Click "Extract specified area" and check "Contains text" and enter the keywords to be extracted; 4. Check "This cell" and click "OK".

Solution:

1. Column A as shown below is part of Taobao product names. Now I want to add all Product names containing the keyword "colorful fir" are extracted.

2. Select the data cell area in column A

3. Click the option below (Excel plug-in, Baidu You can learn the detailed download and installation method, which will not be described in detail here)

4. Click [Statistics and Analysis]

5. Select [Extract specified area]

6. Check [Contain text] and enter [Colorful fir]

7. Check [This Cell], and then click [OK] to complete.

8. The completed effect is as shown in the picture below

Recommended tutorial: "excel tutorial 》

The above is the detailed content of How to extract rows containing keywords in excel?. For more information, please follow other related articles on the PHP Chinese website!