Microsoft KB Archive/31438

Excel 2.x: Edit Repeat Parse Command in Excel PSS ID Number: Q31438 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

When using the Data Parse command in Excel for Windows to parse lines of text, you can use the Edit Repeat Parse command only once. Although this command remains available in the Edit Menu, you must use the Data Parse command before you can use the Edit Repeat Parse command a second time.

You can parse multiple rows by selecting all contiguous rows that will be similarly parsed and then using the Data Parse command.

Microsoft has confirmed this to be a problem in versions 2.0, 2.01, and 2.1 of Excel for Windows. This problem was corrected in version 3.0 of Excel for Windows.

Reference(s):

“Microsoft Excel Reference,” versions 2.x, page 130

“Microsoft Excel User’s Guide,” version 3.0, page 340

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00 3.0

Copyright Microsoft Corporation 1993.