How to keep only numbers in excel table

How to keep only numbers in excel table?

How to leave only numbers in the excel table

1. First, we open the excel office software and use it by specifying the content as a sample

Recommended: "excel tutorial"

2. Select the Start option in the start menu by default, and select Smart Toolbox

3. First, we select the cell area to be processed

4. Then select the cell processing in the toolbar and click on the drop-down triangle Select the retained content

5. A batch extraction window pops up, in which the extraction type selects numbers, because above we mentioned that Chinese and numbers are mixed and only numbers are retained, check the numbers and confirm

The above is the detailed content of How to keep only numbers in excel table. For more information, please follow other related articles on the PHP Chinese website!