View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Importing Data problem

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?