Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) |