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

ID: Q92561

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 :