Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Help w/ Union Queries | Excel Discussion (Misc queries) |