Microsoft KB Archive/67089

{|
 * width="100%"|

How to Control Placement of Carriage Returns in an Alert Box

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
 * Microsoft Excel for OS/2, versions 2.2, 3.0

-

SUMMARY
It is possible to control which lines your text will be displayed on in a Microsoft Excel alert box. Normally Microsoft Excel automatically calculates where the text should wrap and inserts carriage returns accordingly. This prohibits you from entering any type of title or other lines in an orderly manner.

To control where the text should wrap, insert a carriage return using the CHAR function and the ASCII code for the carriage return (which is number 13). For example, =ALERT(&quot;text1&quot;&CHAR(13)&&quot;text2&quot;,2) displays &quot;text1&quot; on the first line and &quot;text2&quot; on the second line of the alert box (without the quotation marks).

Examples
If you enter the following

  =ALERT(&quot;RULES: 1.No rough play 2.No calling names 3.No parties&quot;,2)

The following is displayed:

  RULES: 1.No rough play 2.No calling names 3.No parties

If you enter the following

  =ALERT(&quot;RULES:&quot;&CHAR(13)&&quot;1.No rough play&quot;&CHAR(13)&&quot;.....&quot;,2)

The following is displayed:

         RULES: 1.No rough play 2.No calling names 3.No parties Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0

Keywords :

Version :

Platform :

Issue type :

Technology :