Excel data import skills Regular text

How to import data effectively? If you copy and paste directly, you will find that almost everything goes into the same cell. The following system home Xiaobian will introduce an Excel tutorial "Excel data import skills - regular text". 1. First, let's take a look at the data to be imported. You can clearly see that this data is very regular, and the data is ““| & rdquo; to separate; 2. Under the "Data" menu, select "Export external data", select "Import data", 3. In the "Import data source" dialog box, find the import The data. 4. In the Text Import Wizard dialog box, select “separator" and click Next. 5. & ldquo; separator symbol & rdquo; select & ldquo; other & rdquo; and enter “ & rdquo;, look at the renderings, is not very good separation. 6. In the next step, you can select the data type of each column. In addition, if there is any column that you don't want, you can choose “Do not import this column”. 7. Finally, insert the location selection. If there is no special requirement, the default selection Insert in cell A1. 8. Look at an effect, is it not bad. But one thing you have to remember is that the method is not omnipotent. As shown in the figure, the format of some cells has to be reset!