Home>Article>Topics> How to batch convert text data into numerical format in excel

How to batch convert text data into numerical format in excel

王林
王林 Original
2020-04-18 15:39:16 9833browse

How to batch convert text data into numerical format in excel

First select the area you want to convert to digital format

How to batch convert text data into numerical format in excel

Then click the "Sort" option under "Data"

How to batch convert text data into numerical format in excel

Just click the "Finish" option in the pop-up dialog box, no settings are required

How to batch convert text data into numerical format in excel

Result As shown in the picture:

How to batch convert text data into numerical format in excel

Recommended tutorial:excel tutorial

The above is the detailed content of How to batch convert text data into numerical format in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn