Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
Export file problem for TXT file. | Excel Programming | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Get External Data, Import Text File, File name problem | Excel Programming |