If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|