ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Save as comma csv problems (https://www.excelbanter.com/new-users-excel/240747-save-comma-csv-problems.html)

rock[_2_]

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

Dave Peterson

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


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com