How to import data in txt in excel
- 王林Original
- 2020-06-02 13:35:029559browse
1. Click the [Data] option in the menu bar, then click the [Self Text] option;
2. Check the [Fixed width] option in the text import wizard;
3. Set the data format to [General];
4. Set the data placement location to [Existing worksheet].
After completing the above steps, you will be successful.
Recommended tutorial: excel tutorial
The above is the detailed content of How to import data in txt 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
Previous article：How to convert asterisks to numbers in excelNext article：How to convert asterisks to numbers in excel