asked on 28th Sep 2011 | 1 Answers | Answer It!
You can convert a text file created from another program to a Microsoft Excel file by using the Open command (on the File menu) in Excel. When you open a file, Excel converts the file automatically. You can also import a text file with the Import Data command (Get External Data submenu on the Data menu). When you import a text file, Excel displays the Text Import Wizard, which provides additional flexibility and options for deciding how to import the text file, and then converts the file. Once you import the text file, you may want to change the decisions you made in the Text Import Wizard. Please follow these steps:
1. Click the cell where you want to put the data from the text file. To ensure that the external data does not replace existing data, make sure that the worksheet has no data below or to the right of the cell you click.
2. On the Data menu, point to Import External Data, and then click Import Data.
3. In the Files of type box, click Text Files.
4. In the Look in list, locate and double-click the text file you want to import as an external data range.
5. To specify how you want to divide the text into columns, follow the instructions in the Text Import Wizard, and then click Finish.
6. In the Import Data dialog box, click Properties to set formatting and layout options for the imported data.
7. In the Import Data dialog box, do one of the following:
• To return the data to the location you selected, click Existing worksheet, and then click OK.
• To return the data to a new worksheet, click New worksheet, and then click OK. Microsoft Excel adds a new worksheet to your workbook and automatically puts the external data range in the upper-left corner of the new worksheet.
Here’s to Good Karma
asked on 31st Aug 2011 | 1 Answer
asked on 16th Sep 2011 | 1 Answer
asked on 29th Sep 2011 | 1 Answer
Here's to Good Karma