Skillfully use Excel to format big change body

In the daily work, often encounter some problems of document format conversion, the following author to explain how easy to txt or DOC format documents into Excel spreadsheet document tips.

Convert plain text file into spreadsheet

The first step: Create a new Excel document (new Microsoft Excel worksheet) and open it with the right mouse button. Then, in the new good document, select the file/Open command in the menu bar or click on the "Open" icon in the toolbar, and the following dialog box pops up (Figure 1). In this dialog box, select the text file you want to format, and if you don't see a text file, you can find it by selecting text file or all files in the file Type column of the dialog box.

Figure 1

Step Two: Select the file click the Open button to enter the Text Import Wizard-3 Step 1 dialog box (Figure 2). To provide users with two different file types in the Text Import Wizard-3 Step 1 dialog box, select the appropriate file type depending on the situation. If the text file contains punctuation marks, spaces, or other special symbols in the data, select the "Delimited" column, or "fixed width" If the file's data is not delimited and neatly formatted. Also, in the import Start row of the dialog box, you can select the range of data that you want to import, such as the data content that the user only needs to start with the text file, and then select number N in the item. Excel will only start the data import from the nth row of the text file and ignore all the data before the nth row.

Figure 2

Step three: After you complete these selections, press "Next" to enter the Text Import Wizard-3 Step 2 dialog box. In the Text Import Wizard-3 Step 2 dialog box, set the spacing between each column in the data. If you selected separator symbol in step 1, in step 2 you will select the separator symbol (Figure 3).

Figure 3

The item is a check box, users can combine the following preview to select the appropriate separator as needed, including the TAB key, semicolon, comma, space, and other symbols, and enter the "other" option, if you select "Fixed width" in step 1, In step 2, you adjust the column spacing by modifying the break line (Figure 4). At this point in the Step 2 dialog box in the Data preview item will automatically appear some up arrow, each arrow is equivalent to a column separator, click anywhere in the Preview box to add an arrow, double-click an arrow to remove the arrow, You can adjust the position of the arrow by holding down an arrow to drag it.

Figure 4