Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It will tend not to split at a comma if this falls within a text field
enclosed in quotes, but will split otherwise. It gets more complicated if the field also contains quotes, so if you save as a cvs Excel will double up the quote marks in this situation. -- David Biddulph "Testing" wrote in message ... There does happen to be a ", space" immediately before where the data splits but there are hundreds of those all throughout the data and it doesn't happen in those places. "DaveO" wrote: I've seen this happen in a text field when the field contains a punctuation comma that the import perceives as a delimiter. If you look at the raw file, does that string contain a comma? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem Importing Fixed Width Data | New Users to Excel | |||
Problem importing data into sql server database | Excel Discussion (Misc queries) | |||
Problem importing data from Access | Excel Discussion (Misc queries) | |||
Problem importing external data | New Users to Excel | |||
Importing Data & Refresh Data Problem | Excel Discussion (Misc queries) |