View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default Problem with CSV file

If your example is a direct copy/paste then your problem is that you have a space
preceding the fields subsequent to the 1st field on each record.

--
Regards;
Rob
------------------------------------------------------------------------
"Wayne Wengert" wrote in message
...
I have a CSV file with the following contents (it is quote enclosed/comma
delimited)

===============================
"Dean", "McElroy", "28000 Terrace View Dr.", "Aliso Viejo", "CA", "92656"
"Ramiro", "Barrera", "1900 H Street", "Union City", "CA", "94587"
"Sue", "Smith", "123 Main St.", "Podunk", "CA", "94321"
===============================

When I open that using Excel 2003, the first field (first name) is fine but
all the remaining column contents include the quote marks? How do I get
Excel to remove the quotes?

Wayne