long cell spilling into next cel

  • Thread starter Thread starter davidny26
  • Start date Start date
D

davidny26

I have a cell with about 30,000 characters of html code, I removed the
line breaks, but when I save the file, either as xls csv or to tab
delimited, then reopen, some of the characters appear in other cells.
How can I prevent this?
thanks a lot!
 
My Guess is that your HTML has commas in it. If you have a comma
anywhere in a cell, it usually puts everything passt that comma into a
new cell (for CSV, at least). I am not sure about XLS... Is there a
way to split that over multiple cells? 30,000 characters is a LOT of
data! Excel may just be having issues with that much HTML.

HTH
 
Back
Top