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
Bookmarks