Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
saving a text file to excel
Thanks for feeding back.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) | |||
how can i convert text file to excel file ? | New Users to Excel | |||
Can I use Excel to create this text file? | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) |