Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Question
I currently have a spreadsheet that I need to have saved as a .txt file for a
program to read. I can do this, but when I open the .txt file, one column, Description, is causing all of the other data to be misaligned. I've tried the text to columns-delimited and fixed width, but I don't think I'm doing it right. Can someone help me. Thank you and Happy Thanksgiving |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Question
check your data in the cell that is causing the problem ,,,somthing ax simple
as say door 2,3 instead of door 2-3 "metaltecks" wrote: I currently have a spreadsheet that I need to have saved as a .txt file for a program to read. I can do this, but when I open the .txt file, one column, Description, is causing all of the other data to be misaligned. I've tried the text to columns-delimited and fixed width, but I don't think I'm doing it right. Can someone help me. Thank you and Happy Thanksgiving |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Question
If you show us a few lines of the txt as examples of your data, we may be
able to help. -- David Biddulph "metaltecks" wrote in message ... I currently have a spreadsheet that I need to have saved as a .txt file for a program to read. I can do this, but when I open the .txt file, one column, Description, is causing all of the other data to be misaligned. I've tried the text to columns-delimited and fixed width, but I don't think I'm doing it right. Can someone help me. Thank you and Happy Thanksgiving |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Question
This is the way the current data is being outputed as:
Revenue CPT Allow Allow as Dept Item# Description Price Cost Code Code Links a Link Usage 101 1 INCOMING FAXES 0 0 998 C 101 9999 AFTER HOURS 0 0 998 C 305 3 SEMI PRIVATE R&C(PCC) 1819 813.34 123 99219 R 305 11 OP OBSERVATION (PCC) 1854 816.19 762 99218 C 310 as you can see, the description field overlaps into the price column and causes a snowball affect for everything else. "David Biddulph" wrote: If you show us a few lines of the txt as examples of your data, we may be able to help. -- David Biddulph "metaltecks" wrote in message ... I currently have a spreadsheet that I need to have saved as a .txt file for a program to read. I can do this, but when I open the .txt file, one column, Description, is causing all of the other data to be misaligned. I've tried the text to columns-delimited and fixed width, but I don't think I'm doing it right. Can someone help me. Thank you and Happy Thanksgiving |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import Question
In that format you're not going to be able to make sense of it. You need to
save as comma delimited, or tab delimited, or (if you make the columns wide enough) space delimited [but I wouldn't recommend the latter if you're trying to import into another application]. See what form the program that's going to read the data needs. Which of Excel's "Save As" options have you been using so far? -- David Biddulph "metaltecks" wrote in message ... This is the way the current data is being outputed as: Revenue CPT Allow Allow as Dept Item# Description Price Cost Code Code Links a Link Usage 101 1 INCOMING FAXES 0 0 998 C 101 9999 AFTER HOURS 0 0 998 C 305 3 SEMI PRIVATE R&C(PCC) 1819 813.34 123 99219 R 305 11 OP OBSERVATION (PCC) 1854 816.19 762 99218 C 310 as you can see, the description field overlaps into the price column and causes a snowball affect for everything else. "David Biddulph" wrote: If you show us a few lines of the txt as examples of your data, we may be able to help. -- David Biddulph "metaltecks" wrote in message ... I currently have a spreadsheet that I need to have saved as a .txt file for a program to read. I can do this, but when I open the .txt file, one column, Description, is causing all of the other data to be misaligned. I've tried the text to columns-delimited and fixed width, but I don't think I'm doing it right. Can someone help me. Thank you and Happy Thanksgiving |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Import Wizard (use for large files) | Excel Discussion (Misc queries) | |||
Import Data with Macro or VBA | Setting up and Configuration of Excel | |||
import question | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Automatic Data Import | Excel Discussion (Misc queries) |