Displaying Array

Casey · Apr 4th, 2002, 01:03 PM

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 · Apr 4th, 2002, 01:30 PM

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 · Apr 4th, 2002, 01:31 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 01:03 PM	#1
Casey Board Regular Join Date: Feb 2002 Posts: 82	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

Apr 4th, 2002, 01:30 PM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	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?