Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with data that has been exported from a database that is
displaying some odd behavior in Excel 2003 SP3. The problem seems to be that the final column in the database allows html to be entered, so when we export it to Excel, all of the tags show up with the data. In SP3, some of this data from the final column is being broken up and displayed in multiple cells. So, for example, in a cell that has multiple lines of text with tags in between, the first line appears where it should, the second line displays on the next row, but in the first column instead of the last, the next line in the row below that, etc. In SP2, it displays normally: we still see the tags mixed in with the data, but nothing spills over. Has anyone else experienced a problem like this, or have any idea what changed between SP2 and SP3 that could be the cause of the issue? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DOES ANYONE KNOW IF EXCEL READS ITEMS IN A LIST DIFFERENTLY ? | Excel Discussion (Misc queries) | |||
Pivot table displays data differently, Excel 2003 | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
When I send a spreadsheet via e-mail they see it differently? | Excel Discussion (Misc queries) | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |