Import from file:
Then in Excel, open the .txt file you had just saved. It should ask you to descriibe your data, you should choose "Delimited", then specify "Tab" as the Delimiter. These values should be the default choices in Excel, so you should be able to just keep clicking "Continue" in the dialogue boxes until it is finished opening your file.
Copy and Paste:
Then in Excel, open a blank sheet. It it doesn't already present a blank sheet, click on the leftmost icon (a blank sheet) on the tool bar. On the blank sheet, click the left mouse button on the very first cell which appears in the upper left-hand corner of the spreadsheet. It is the blank cell to the left of the "A" cell and above the "1" cell. By clicking on this cell with the left mouse button, the entire spreadsheet becomes highlighted. Now on the menu bar of Excel, click Edit -> Paste Special.
A dialogue box may pop up asking you to choose a format "As": choose "Text", then click "OK". Another dialogue box may pop up asking: "Data on the clipboard is not the exact size and shape as the selected area. Do you want to paste the data anyway?". Click "OK" and the data will be pasted into the spreadsheet.
|Home||© Wild Ones®. All rights reserved.
Updated: Jun 12, 2005.