Change method: First select the excel table, right-click the mouse, and select "Open with"; then select "Select another application to open" and click the "Notepad" icon button; then click "File" at the top of the page -"Save as", select "ANSI" format in "Save as type" to save; finally open the file with excel.
The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.
Open the form, and there are a bunch of garbled characters that we can't understand.
Close the form, return to the folder where the file is located, place the cursor on it, right-click, and click Open with.
Observe the interface carefully and click to select other applications.
The system jumps to the drop-down menu, find the notepad icon, click it, and click the OK icon below.
#After opening the table in Notepad, click the file icon in the upper left corner and select Save As in the pull-down menu.
In the Save As property box, confirm the saved path and file name. The most important point is here. We select the ANSI format in the encoding and click Save on the right.
After completion, open this file with Excel. At this time, the data will become normal.
Related learning recommendations: excel tutorial
The above is the detailed content of How to correct the garbled code in excel table. For more information, please follow other related articles on the PHP Chinese website!