ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   UNION of Arrays - is possible? (https://www.excelbanter.com/excel-discussion-misc-queries/66200-union-arrays-possible.html)

Marina Limeira

UNION of Arrays - is possible?
 
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



Gilles Desjardins

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





All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com