Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/92561

From BetaArchive Wiki

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.