saving a text file to excel
 

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?


--


If you wish to reply using e-mail, please add a 35 (the number) after
bullseye.

saving a text file to excel
 

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

saving a text file to excel
 

Pete_UK wrote:
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.

--


If you wish to reply using e-mail, please add a 35 (the number) after
bullseye.

saving a text file to excel
 

Thanks for feeding back.

Pete