 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007long cell spilling into next cel
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 -- Aaron C On Nov 9, 5:45 am, davidn...@yahoo.com wrote: > 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!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.