Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel2007 importing issue/bug
Hello
I have a .csv (comma separated) file with names, addresses and notes in. When I double click it, the file opens file and all values are displayed in separate cells. However, when I import it, the fields merge and split on their own. The commas seem to be ignored. This seems to happen whenever the notes field has a paragraph in. So instead of displaying a new line in the same cell, Excel07 starts a new row in my spreadsheet! I'm importing via "import types, text, choosing field delimited, comma." Has anyone else had import problems? (Some of my customers need to import. I'm not just asking for the good of my health :) Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help with Excel2007 | Excel Worksheet Functions | |||
excel2007 hotkey | New Users to Excel | |||
Excel2007 - More columns when importing ascii file? | Excel Discussion (Misc queries) | |||
Importing data to excel (newline/carriage return issue) | Excel Discussion (Misc queries) | |||
Importing from Access issue | Excel Discussion (Misc queries) |