Displaying Array

[Casey]

Does anyone know how to display an array in a cell without having to type each thing and concatenating like array(1) & array(2) & array(3) & etc
thanks
Casey

 

[Dave Patton]

What do you mean by Array1 etc?

Is this in a Sub?

A very concise example could make your question much clearer.

If you mean a range of cells?

One could create a User-Defined Function to concatenate a single range?

 

[Aladin Akyurek]

On 2002-04-04 12:03, Casey wrote:
Does anyone know how to display an array in a cell without having to type each thing and concatenating like array(1) & array(2) & array(3) & etc
thanks
Casey

Dowload Longre's morefunc.zip from:

http://perso.wanadoo.fr/longre/excel/downloads/

that contains a UFD, called MCONCAT.

=MCONCAT(A1:A5,",")

will concatenate the values in A1:A5, separated by commas.

=MCONCAT(A1:A5,",")&","&MCONCAT(B1:B5,",")

will do the same for two ranges of values.

Aladin