How to import data in txt in excel

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!