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
|