View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cantona cantona is offline
external usenet poster
 
Posts: 1
Default 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!