sas dataset to excel display

[SASuserlot]

I have the variable value as this in my dataset

Randomized,^nControl ,^nCrossr^n safety/efficacy/clinical trial

^n used to in the proc report to read every word after this will display in next line (excapechar=^)

like this need to be displayed in my excel ods shell

Randomized,

control placebo,

cross,

safety/efficacy/clinical trial

But it displaying as

Randomized,

control placebo,

cross,

safety/efficacy/clinical

trial

by the way this is the longest string in the Variable, I have small one before and after it, so assigned the length . any suggestions greatly appreciated

[jimbarbour]

Well, an imperfect solution at best, but you could try replacing the space with an underscore.  Like this:  

safety/efficacy/clinical_trial.  You could also try a non display character like '1A'x or '1F'x, but test thoroughly.  

Jim

[Reeza · Accepted solution]

Have you ensured the width of the cell is large enough? 

[SASuserlot]

I tried increasing the cell width, but no use for some reason.

[SASuserlot]

Thanks, for some reason I increased width a lot then it worked now. Did not expected the width is that big compare to other