Using the Excel Data Parse Command without a Mouse

Last reviewed: November 1, 1994
Article ID: Q27586

The information in this article applies to: - Microsoft Excel for Windows versions 2.x, 3.0 and 4.0 - Microsoft Excel for OS/2 versions 2.2, 2.21, and 3.0

SUMMARY

If you use the keyboard with the Data Parse command in Excel, and press the LEFT ARROW and RIGHT ARROW keys to move the cursor on the parse line, the data disappears.

MORE INFORMATION

When Excel displays the data in the parse line, it assumes a cell to be 255 characters in length. When the arrow keys are pressed, Excel inserts the cursor at the right end of the cell being parsed. In other words, the data is still present, but it is at the left end of the cell.

To get to the left end where the data appears, press the HOME key and then use the arrow keys to place the cursor where you want it. You can then insert brackets by typing them in the appropriate places, and remove them by using the BACKSPACE or DEL key.

KBCategory: kbother
KBSubcategory:
Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20 3.00
3.0 4.00 4.0

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.