How do you keep Character Return/Hard Returns When you Export to Excel?

[patbuchanan]

I've built a pivot table and my formatting looks great in Qlikview but i'm being asked to deliver the report in Excel and when I export to Excel it loses my formatting for my character/hard returns.   I've got multiple fields I'm combining and I need each field to be on a separate line and I've tried chr(10), chr(13) & chr(9) and none of them keep the formatting when I export to Excel.

Below is a sample of my formula:

=Text(FSScheduleID & chr(10) & EventTitle & chr(10) & '('& EventStartDayofWeek & '-' & EventEndDayofWeek & ' ' & EventTime & ')' & chr(10)) & Concat(Distinct RoomDescription, ' : ')

Looks right in Qlikview:

Export to Excel and loose my formatting:

[Anonymous · Accepted solution]

The alignment in the Excel cells needs to be set to wrap text.