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! |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com