View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
rock[_2_] rock[_2_] is offline
external usenet poster
 
Posts: 12
Default 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