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 "Microsoft Excel User's Guide 1," the array formula
{=TRANSPOSE({1,2,3:"A","B","C"})}
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 "Microsoft Excel User's Guide 1."
REFERENCES
"Microsoft Excel User's Guide 1," version 4.0, pages 159 and 163
Additional query words: transpose
Keywords :
Version :
Platform :
Issue type :
Technology :
Last Reviewed: March 29, 1999 |
