Microsoft KB Archive/92561

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 17:33, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.