How to import formatted text into excel

Open excel, select data, self-text, and select formatted text

The system pops up the text import wizard step 1, you can Preview the data of the file to be prepared

Set the delimiter in step 2 of the text import wizard. Since the test data uses commas, select commas here

Set the data format of each column in step 3 of the text import wizard and click [Finish]

Recommended tutorial: excel tutorial

The above is the detailed content of How to import formatted text into excel. For more information, please follow other related articles on the PHP Chinese website!