Date:         Tue, 25 Nov 2008 10:51:58 -0600
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Inserting a newline in Excel
Comments: To: John Hendrickx <John2.Hendrickx@GMAIL.COM>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

I found out (by mistake!) that adding a slash in a define using Proc Report
will put a return key in the cell, such as

define isv_od_ph_mr/display 'PH/MR OD';

will display the header to the cell as having a PH followed by a newline
followed by MR OD.

-Mary

----- Original Message -----
From: John Hendrickx
To: SAS-L@LISTSERV.UGA.EDU
Sent: Tuesday, November 25, 2008 9:59 AM
Subject: Inserting a newline in Excel


Does anyone know of a way to insert a newline in Excel using the
ExcelXP tagset? I can do it in an RTF file using ^n but that doesn't
work in Excel. I can do it manually in Excel by pressing Alt-Enter,
which apparently inserts a linefeed character '0A'x. But inserting
linefeeds doesn't work. I've tried ^l, <br>, nothing I've tried works.
Any suggestions?

John Hendrickx

Statistician
Clinquest Europe BV, Oss - The Netherlands
www.clinquest.com