Rockwell Automation FactoryTalk View Machine Edition Users Guide - Manual (Page 210)

F ACTORY T ALK V IEW M ACHINE E DITION U SER ’ S G UIDE
12-10
• •
•
•
•
Open the text file in Microsoft Excel
When you open the text file in Microsoft Excel, the Text Import Wizard appears.
To specify the file format (Step 1 of the wizard)
1. Click Delimited.
2. In the Start import at row box, type or select 1.
3. In the File origin list, click Windows (ANSI).
4. Click Next.
To specify the field delimiter (Step 2 of the wizard)
1. Select the Tab check box. If any other check boxes are selected, clear them.
2. Make sure the “Treat consecutive delimiters as one” check box is cleared.
3. Click Next.
To specify the column data format (Step 3 of the wizard)
1. If it is not selected already, under Column data format, click General.
2. Click Finish.
Save the text file in Microsoft Excel
To save the file
1. From the File menu, select Save.
Excel warns that the file may contain features that are not compatible with Unicode
text.
2. When prompted to keep the workbook in Unicode format that leaves out incompatible
features, click Yes.
3. Close the file.
4. When prompted to save changes, click Yes.
5. When prompted again to keep the workbook in Unicode format that leaves out
incompatible features, click Yes.