Microsoft KB Archive/28990

Works Does Not Support Parsing

PSS ID Number: Q28990 Article last modified on 10-22-1998

1.00 1.05 2.00 3.00 | 2.00 3.00

MS-DOS WINDOWS

================================================================ ==

The information in this article applies to:

 Microsoft Works for MS-DOS, versions 1.x, 2.0, 3.0 Microsoft Works for Windows, versions 2.0, 3.0 == Microsoft Works version 4.0 for Windows 95 == 

= SUMMARY =

Works does not include a feature that separates copied text data into columns (parse).

= MORE INFORMATION =

To work around this issue, use any of the following methods:

Method 1
Use a function to extract a portion of a spreadsheet cell or database field. In Works 3.0, the LEFT, RIGHT and MID functions can be used to extract portions of a spreadsheet cell or database field. For example, if cell A10 contains the phrase “Works for MS-DOS,” then the following function would return the word “Works”:

=LEFT(A10,5)

Method 2
Separate the words into different cells in the spreadsheet. To do this, follow these steps.


 * 1) In your Works spreadsheet, click Save As on the File menu.
 * 2) Type a new name in the File Name box, click Text & Tabs in the Save As Type box, and then click Save.
 * 3) On the File menu, click Open, click Text (*.txt) in the Files Of Type box, and then click the file that you want to open.
 * 4) Click Open, and then click Word Processor.
 * 5) Insert a tab in each place where you want to divide information between different cells.
 * 6) On the File menu, click Save As, click Text in the Save As Type box, and then click Save.
 * 7) On the File menu, click Close.
 * 8) On the File menu, click Open, click Text (*.txt) in the Files Of Type box, and then click the file that you want to open.
 * 9) Click Open, and then click Spreadsheet.

NOTE: Formulas and functions need to be retyped or copied from the original spreadsheet file.

= Additional query words: parceling parcing parsing separating database =

Version : 1.00 1.05 2.00 3.00 | 2.00 3.00 Platform : MS-DOS WINDOWS Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1998.