Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |