Export to Excel while Preserving Carriage Returns

building reports webintelligence
1

I use the char(13) function in WebI to include some carriage returns in a variable created in WebI. However when I export my report the report to Excel, the carriage returns are removed. is there anyway to have Excel recognize WebI’s carriage returns?

BO XI rel. 2
Microsoft Excel 2007

adricey :jamaica: (BOB member since 2008-07-09)

2

Hi,

Try using Char(10) instead.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Like magic! Thanks!

adricey :jamaica: (BOB member since 2008-07-09)