Hi,

I'm afraid it's not at all clear what you mean here.

With respect to a single-cell formula (as opposed to a multi-cell array formula, which is a different matter), an array of values is never 'contained' within, nor can be transferred to, the cell containing that formula. Rather that array is stored 'in-formula', from which, if desired, may be output single values into actual worksheet cells.

If you attempt to 'evaluate' a formula which returns an array of values - i.e. output a result to an actual worksheet cell - then you will not succeed; instead, only the first entry in that array will be returned. A formula such as

=A1:G1

placed within a single cell, is completely redundant (whether committed with CTRL+SHIFT+ENTER or not), since a single cell can never return an array of values. Whereas something like:

=MAX(A1:G1)

for example, makes perfect sense.

Regards