| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Save as comma csv problems
Hello,
I hace Excel 2002. I have near 6000 addresses and contacts and wish to save the xls to a comma csv. I have done that before and then imported the comma csv into my membership program were it says 'import comma csv'. The problem is that some (300 odd) of the records are not imported correctly. I think this maybe because here are some commas in some of the fields eg 24 my street, whatever. Would that be the cause, and if so how can I get rid of all the commas? Many thanks rock |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Save as comma csv problems
Check your other post.
rock wrote: Hello, I hace Excel 2002. I have near 6000 addresses and contacts and wish to save the xls to a comma csv. I have done that before and then imported the comma csv into my membership program were it says 'import comma csv'. The problem is that some (300 odd) of the records are not imported correctly. I think this maybe because here are some commas in some of the fields eg 24 my street, whatever. Would that be the cause, and if so how can I get rid of all the commas? Many thanks rock -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Problems in Comma Separated List | Excel Worksheet Functions | |||
| How to save data in CSV format when a field also contains comma? | Excel Discussion (Misc queries) | |||
| Changing a comma separated text file and save it. | Excel Discussion (Misc queries) | |||
| How do I save format changes in a comma delimited file? | Excel Worksheet Functions | |||
| save an Excel worksheet as a comma delimited file? | Excel Discussion (Misc queries) | |||
![rock[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
