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!