How do fixed-form text be converted to Excel tables?

For example, there is a text file whose name is "Address Book. txt", which has a header row and a content row, and each row is made up of a "vertical bar" character (that is, the English character "|") Separated. The contents of the entire file are shown in the figure.

1, open Excel, press CTRL + O to bring up the Open dialog box, set the file type in the dialog box to text file, navigate to the location of the text file in step 1th, and click the "Address Book. txt" file-open.

2. Excel pops up the Text Import Wizard dialog box. Because the "Address Book" text file is delimited by a "vertical bar" character, so in "Select the most appropriate file type", we leave the separator symbol unchanged and click Next.

3, in the "separator symbol", remove the "tab", "semicolon", "comma", "space" before the check, select "Other", and then in the "Other" text box, enter the "vertical bar" character, that is, "|" This symbol. Note that this symbol must be entered in the English state. In addition, select None in the text recognition symbol.

4, Next, set how Excel recognizes the numbers in the text file. Click on the "Mobile number" column and select "Text" in the column data format. The goal is to prevent Excel from removing the "0" in front of the number. In the same way, set the "Fixed Phone" column.

You can also see that if a date is stored in a text file, you can specify it as a "date" format in this step to facilitate the calculation of dates for this column after the conversion is complete.

5. Click "Finish" button to complete the operation of the fixed-format text file import Excel.