long cell spilling into next cel

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!
 
A

Aaron C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Individual Character fonts in a cell 12
Text in merged cells is spilling over 3
Split cells with hard-coded line breaks 3
Can not replace commas - "formula too long" 7
XL2010 messing up my templates 2
Odd character display (ASCII 128-159) 1
Problem with Concatenate - Results are too long for CSV 4
Save As... results in ####### 3

Top