Microsoft KB Archive/68088

WP File Must Be Tab Delimited to Copy to Database/Spreadsheet

PSS ID Number: Q68088 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

When copying information from a word processing document to a database or spreadsheet document, the file must be delimited by tabs, not commas. If it is separated by commas, the information will be copied into a single field/column.

This limitation does not apply to text files that are imported using the File Open Existing File command.

= MORE INFORMATION =

To create a tab-delimited file from a comma-delimited file, use the Select Replace command.


 * 1) From the Select menu, choose Replace.
 * 2) Search for “,” (comma, without the quotation marks) and replace with “^t” (without the quotation marks).
 * 3) Choose Replace All.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.