View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wayne Wengert Wayne  Wengert is offline
external usenet poster
 
Posts: 16
Default Problem with CSV file

There is no copy/paste involved, the file is from an external source.

Wayne

"RWN" wrote in message
...
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