Convert bidirectional text files to and from ANSI

The ConvText utility is available on the installation CDs for Microsoft Office language versions that offer right-to-left support. ConvText provides more support (additional code pages (code page: A table that relates the binary character codes used by a program to keys on the keyboard or to the appearance of characters on the display. Code pages are a means of providing support for the languages used in different countries/regions.) and visual text layout (visual: Used to describe insertion point movement and text selection when working with bidirectional text. Movement progresses within bidirectional text by moving to the next visually adjacent character.) options) than the following features when converting bidirectional (bidirectional: Describes an environment in which attributes of right-to-left and left-to-right behavior are used together, such as Arabic and English text that appear in the same sentence.) files to ANSI (ANSI character set: An 8-bit character set used by Microsoft Windows that allows you to represent up to 256 characters (0 through 255) by using your keyboard. The ASCII character set is a subset of the ANSI set.) characters:

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.
 
 
Applies to:
Excel 2003