View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gilles Desjardins
 
Posts: n/a
Default UNION of Arrays - is possible?

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

Hope this helps

Gilles
"Marina Limeira" wrote in message
...
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