saving a text file to excel

[bullseye]

I have 5 columns that appear well formatted in a Notepad file but when I
copy and paste into Excel, they all get jumbled. How do I copy and
paste this document while keeping the same formatting from a Notepad
file into Excel?

 

[Pete_UK]

Start Excel then do File | Open and point to the folder with your text
file in (you may need to change the file type to "All files *.*") then
select you file and click Open.

Excel will then automatically enter the Text Import Wizard, which has 3
phases - in the first phase you can specify which row to start with and
whether the data is fixed width or delimited. In the second phase you
can specify the delimiter (if any) and the text qualifier (" is
assumed). Then in the final panel you can specify the data type for
each field. When you click Finish the data should appear within Excel -
you might have to adjust the width and format for each column and if
you do File | Save As then make sure you select Excel Workbook as the
type.

Hope this helps.

Pete

 

[bullseye]

Start Excel then do File | Open and point to the folder with your text
file in (you may need to change the file type to "All files *.*") then
select you file and click Open.

Excel will then automatically enter the Text Import Wizard, which has 3
phases - in the first phase you can specify which row to start with and
whether the data is fixed width or delimited. In the second phase you
can specify the delimiter (if any) and the text qualifier (" is
assumed). Then in the final panel you can specify the data type for
each field. When you click Finish the data should appear within Excel -
you might have to adjust the width and format for each column and if
you do File | Save As then make sure you select Excel Workbook as the
type.

Hope this helps.

Pete

It works. Thank you.

 

[Pete_UK]

Thanks for feeding back.

Pete