Naija Ryders - View Single Post

Chxta · 05-29-2007, 10:34 PM

Nothing equals Excel for crunching of numbers (even the most rabid Linux proponents accept that Excel is way ahead of Open Office Spreadsheet...), but what if your data isn't already in an Excel spreadsheet? It's as simple as using the Text Import Wizard.

Open a blank or existing Excel 2007 spreadsheet. Click the Data tab on the Ribbon and choose "From Text".

Choose the text file you want to import and double click. This will open the Text Import Wizard. Choose your data type and which row you want to start the data at and click next.

Step 2 of the Wizard allows you to manage the break lines between your data.

Step 3 of the Wizard allows you to choose column formats, provides data preview, and other advanced settings. When everything is organized click on Finish.

A final window will be displayed asking where you wish to put the data into the sheet. Here you can see I chose A6. Click OK…

Your Text Data will now be input into the Excel sheet!

05-29-2007, 10:34 PM	#78 (permalink)
Chxta Registered User Join Date: Nov 2007 Location: 3rd rock from the Sun Posts: 8,541 Points: 9,667.30 Bank: 0.00 Total Points: 9,667.30 Donate Rep Power: 21474863	Import Text into Excel 2007 Nothing equals Excel for crunching of numbers (even the most rabid Linux proponents accept that Excel is way ahead of Open Office Spreadsheet...), but what if your data isn't already in an Excel spreadsheet? It's as simple as using the Text Import Wizard. Open a blank or existing Excel 2007 spreadsheet. Click the Data tab on the Ribbon and choose "From Text". Choose the text file you want to import and double click. This will open the Text Import Wizard. Choose your data type and which row you want to start the data at and click next. Step 2 of the Wizard allows you to manage the break lines between your data. Step 3 of the Wizard allows you to choose column formats, provides data preview, and other advanced settings. When everything is organized click on Finish. A final window will be displayed asking where you wish to put the data into the sheet. Here you can see I chose A6. Click OK… Your Text Data will now be input into the Excel sheet! __________________ I have never killed a man, but I have read many obituaries with great pleasure.