View Single Post
  #1   Report Post  
Hadyn Pkok
 
Posts: n/a
Default ?? Extra blank lines in 'address' cell after exporting to Excel

OS = XP Pro latest sp; MSOffice Pro 2003 latest sp

I am using SQL Reporting Services (Sp1) to export data to Excel. The SQL
query grabbing the data requires a case statement with carriage returns to
format Address data. For instance the output looks as follows:

SRT: ATTN: Sales
1603 Plasma Ave
Stonewashed, IL 60135

When I export the report to Excel, the cell containing the address info gets
formatted with a blank line (within the cell) between each address line. For
instance:

SRT: ATTN: Sales

1603 Plasma Ave

Stonewashed, IL 60135

Is there a way to update the address column to remove these blank lines? I
have attempted various formatting tricks in SQL Reporting Services and
nothing seems to work. So, I thought there might be a way to export the data
to Excel then update that column to remove the blank lines.

Any help would be welcome...

Hadyn