Problem in evaluation of formula with F9

Hi, I create an array of the style =SEQUENCE(2000) or any equivalent version with ROW(INDIRECT()) etc.

When I evaluate this with F9, I get as the last values: 1855;1856;䀄㕸Χ晔䀄

Can anyone explain to me what is going on here? (Any formulas where I use this, work fine though. Similarly, when I extract its values, it doesn't yield the above symbols.)

Thanks

I was thinking of Excel limitations first, too. I guess I was a bit lazy to look it up.
At Item 1856 we're at around 6300 characters.
https://support.office.com/en-us/art...7-269d656771c3
Also mentiones the 8,192 max. length that you reference.

The cutoff seems to be 1863 = at least 6345 characters + the semicolons, + maybe the {} gets us to the limit it seems.

How the formula ends is a puzzle to me though.

UNICODEs:
 4
䀄 16388
㕸 13688
Χ 935
晔 26196
 4
䀄 16388

If I change it to e.g.: =IF($AF$1#,111,) the last items are: 䀃㘮蜈䀃晔ʄ䀃
which equate to unicode characters:

䀃 16387
㘮 13870
蜈 34568
 3
䀃 16387
晔 26196
ʄ 644
 3
䀃 16387

I personally use F9 to (part)evaluate formulas all the time.
It's much faster than the Evaluate tool and more keyboard friendly; I recognize that F9 can yield wrong results in some instances where the Evaluate tool does not but these scenarios are so niche that they play virtually no role for me.

Regards

As far as I can tell, these symbols are random, too, i.e. this is nothing meaningful in Chinese eiter.

Can anyone with other/older versions of Excel check the same and let us know their outputs?

E.g. the example fo XOR LX yields for me with F9 as the last results: ;"A垟

While =ROW(INDIRECT(("1:2000"))) yields: ;1856;䀄㕸Χ晔䀄 for me.

Originally Posted by XOR LX

Hi,

Either it's a new feature or a bug! I get the same, though I haven't managed to find any official documentation on this yet.

Regards

I just checked with Excel 2016 and there such F9 evaluation is not possible. It gives a straight error message "You can't use more than 8192 characters in an Microsoft Excel formula.".

Regards