Converting files to Excel Spreadsheet format

  • Thread starter Thread starter Robert Stokes
  • Start date Start date
R

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?
 
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.
 
Back
Top