Microsoft KB Archive/92561

{|
 * width="100%"|

Excel: Semicolon Should be Used to Separate Rows of an Array

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
On page 163 of the version 4.0 &quot;Microsoft Excel User's Guide 1,&quot; the array formula

  {=TRANSPOSE({1,2,3:&quot;A&quot;,&quot;B&quot;,&quot;C&quot;})}

is incorrect. The colon should be a semicolon. The appropriate row separator for an array is a semicolon. This information is stated in the second paragraph on page 159 of the version 4.0 &quot;Microsoft Excel User's Guide 1.&quot;