It's my first time trying to use this function and when I try to create a
simply one like ={1,2,3,4;5,6,7,8} and Ctrl + Shift + Enter. The only thing I
have is on the to rows, in the first column 1, on the second one 2, on the
third one 3 and at least 4 on the last one. But I should have 1234 on the
first row and 5678 on the second row.
I don't understand, what is going wrong?

Please help. I'm using excel 2003

Jean-Jacques,

Select a 2 row by 4 column block of cells prior to entering your array.

Your formula bar should show

{={1,2,3,4;5,6,7,8}}

when you've entered it correctly.

HTH,
Bernie
MS Excel MVP


"Jean-Jacques Basse" <Jean-Jacques wrote in message
...
It's my first time trying to use this function and when I try to create a
simply one like ={1,2,3,4;5,6,7,8} and Ctrl + Shift + Enter. The only thing I
have is on the to rows, in the first column 1, on the second one 2, on the
third one 3 and at least 4 on the last one. But I should have 1234 on the
first row and 5678 on the second row.
I don't understand, what is going wrong?

Please help. I'm using excel 2003