Hadyn

The blank lines could be caused by carriage returns in the data.

Try selecting the column then EditReplace

what: hold ALT key and type 0010 on numpad at right-side of keyboard.

with: nothing

Replace all.


Gord Dibben Excel MVP

On Fri, 15 Apr 2005 12:22:01 -0700, "Hadyn Pkok" <Hadyn
wrote:

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