Converting files to Excel Spreadsheet format

[Robert Stokes]

I have a Notepad file that I would like to convert to an
Excel spreadsheet. I have copied and pasted but the
format is not in a usable form. I have also tried to
AutoFormat but that makes the spreadsheet look even
worse. This data needs to be placed in Excel to cut down
on the data entry time for another application. Am I
missing something?

 

[David McRitchie]

Hi Robert,
When you open your stokes.txt file in Excel, you will be
presented by the Import Text Wizard, you chose either
- Delimited, if you have a character to separate the cells on the rows, or
- Fixed Width, if you lined up columns when using a fixed font.

If your file has a .csv file extension then the Import Wizard will
make it's own choices as to what you have, and you are not likely
to put up with such results..

If you already have data in Excel and it is all in one column then
Data, Text to Columns is the same as the Import Text Wizard in usage.