UNION of Arrays - is possible?

M

Marina Limeira

how I union this 3 text arrays ?

example:

A = array("mary", "john")
B = array("Peter")
C = array("Roger")

How to do the D array?

D = A + B + C

thanks

Marina
 
G

Gilles Desjardins

I think you mean connect. try in cell D the following: ==A1&" "&B1&" "&C1
Or use the Concatenate function.

Hope this helps

Gilles
 
Top