LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default double blank lines in cells

Our software generates reports by exporting data to xml, and then
transforming it by xsl into an "excel-readable" format. When there are longer
texts to be displayed in one cell, word wraps in the original text appear
double in the excel cell, for example when
line1
line2
is the original text, in excel it appears as
line1

line2
How do I get rid of the blank line? We tried every code for word wraps/line
feeds we could think of, like "\n", "chr(10)",
"... and so on, but nothing
works.
Can anyone help?
Thanks,
Björn Göhringer
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
blank lines in text cells Ed Williams Excel Discussion (Misc queries) 4 March 14th 08 03:47 PM
blank lines in text cells Ed Williams[_2_] New Users to Excel 1 March 14th 08 03:47 PM
Enter various number of blank lines in cells Jim New Users to Excel 2 March 3rd 08 02:15 AM
grid lines printing with blank cells [email protected] Excel Discussion (Misc queries) 1 March 28th 07 03:28 AM
Blank lines in cells Dan Excel Discussion (Misc queries) 1 October 17th 05 03:51 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"