Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet with around 125 records and 130 fields. Not all of the
fields are populated for all records; several of the fields have no entries at all. When I save the file in .csv format, each record gets a line break in a different place. I can't correlate it with the length of the record in characters or fields, or with which fields are/aren't populated. It appears that each record is being broken into 4 pieces. This makes it impossible to import the file into the target application. Can anyone help me eliminate or at least learn how to work around the problem?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I get excell to ignore line breaks? | Excel Discussion (Misc queries) | |||
manual line breaks | Excel Discussion (Misc queries) | |||
Adding line breaks by using find and replace | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions | |||
can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) |