Convert bidirectional text files to and from ANSI

Microsoft Office Excel 2003

previous page next page

  • The Microsoft Excel Text Import Wizard for converting right-to-left characters in bidirectional files to ANSI characters with logical text layout.

  • The Microsoft Excel Save As command (File menu) for converting ANSI characters with logical text layout to other bidirectional file formats.

    • The following examples illustrate how to use ConvText with Excel. Similar steps are required to use ConvText with other Microsoft Office applications such as Access.

    ShowConvert bidirectional text files to ANSI

    1. In the Program Files\Microsoft Office\Office11 folder, double-click the ConvText.exe icon.
    2. Click Convert To Windows ANSI Code Page.
    3. Type file names in the Source and Target boxes, or click Browse.
    4. Do one of the following:
      • Click Load to retrieve a previously saved conversion specification.
      • Select the code page, text layout, file type, and any other relevant parameters that match the target text file to be created.
    5. Click Save to retain the conversion specifications.
    6. Click Convert.
    7. Import the converted text file into Excel.

    All field names and records from the original table or worksheet will be fully recreated in a new table.

    ShowConvert bidirectional text files from ANSI

    1. Save a copy of the worksheet you want to convert to a non-ANSI code page.
    2. In the Program Files\Microsoft Office\Office11 folder, double-click the ConvText.exe icon.
    3. Click Convert From Windows ANSI Code Page.
    4. Type file names in the Source and Target boxes, or click Browse.
    5. Do one of the following:
      • Click Load to retrieve a previously saved conversion specification.
      • Select the code page, text layout, file type, and any other relevant parameters that match the target text file to be created.
    6. Click Save to retain the conversion specifications.
    7. Click Convert.
    previous page start next page