UNION of Arrays - is possible?

  • Thread starter Thread starter Marina Limeira
  • Start date Start date
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
 
I think you mean connect. try in cell D the following: ==A1&" "&B1&" "&C1
Or use the Concatenate function.

Hope this helps

Gilles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching 2 list of data array, and return it as True if matched 1
excel array 2
Shape Arrays VBA 0
Need to return an array 3
How to use Sumifs with vertically and horizontally criterias 1
Using Named Range within an Array Formula 2
Array Constant 3
linear interpolation macro help 1

Back
Top