Please ask excel table text categorization how to do ah? I want to put the following column of the type of categorization, such as categorized as quilt class pillow class seat class, etc. Please how t

Please ask excel table text categorization how to do ah? I want to put the following column of the type of categorization, such as categorized as quilt class pillow class seat class, etc. Please how to do? Step 1, insert a column in front of this column, and then, in front of the "trade name" in a form fill in the "category"

Step 2, with a point to select the "category" and "name" of the goods " and "Trade Name" two forms, and then click the toolbar "Data", "Filter", "Automatic Screening", the key to this step is the application of Excel's screening function.

Step 3, click the "Category" form of the lower right corner of the small triangle, and then, click "(blank)".

Step 4: Click the small triangle at the bottom right corner of the "Product Name" form, and then, click "Custom" to bring up the Custom Filter dialog box.

Step 5, in the dialog box, the "equal to" field Replace "Contains" with "Contains", fill in the empty field to the right of "Pillow", then "OK".

Step 6, use the mouse to select the "category" below the more than 10 consecutive spaces, the number of selected spaces and the right side of the screened goods flush, and then in the toolbar edit field fill in the "pillow", and then hold down the keyboard above the "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl", "Ctrl". "Ctrl" key and do not let go, hit the Enter key.

Step 7, repeat the above 4, 5, 6 three steps, the difference is that the pillow will be replaced by "tent", "mat", "pieces of" and other different The difference is that the pillows will be replaced by other different keywords such as "tent", "mat", "cover", etc. The keywords will be filtered out and the category name will be filled in. If you can't remember the keywords in your mind, before repeating step 4, click on the small triangle at the bottom right corner of the "Product Name" form, then click "(All)" and repeat steps 4, 5, and 6.

Step 8, after a number of screening, classification operations, if the basic classification has been completed, then click on the toolbar "Data", "Filtering", "Automatic Screening" to remove the screening function. For a small number of missing fish, you can check one by one, fill in the classification, or repeat the above screening steps.

Excel's formulas and functions are also very powerful, such as the list of goods in these commodity names, size specifications with a function all at once out and so on. If you need to understand the relevant operation can also find me. :) typing so many words is not easy, look forward to timely adoption.