Do u want to create 1 dimensional array by joining them? or 2 two dimensional array?
If it is one dimensional...
as you had split the string..i am joining back all the array elements as a single string and do a final split to create an array...
But it might not be a good approach...because if the array element itself has the delimiter as content (%^&)..then the result might not be as expected..
so create a function and create an array in it with a size by adding 2 array sizes. then use for loop to iterate thro passed array elements and to store it in the new array.
If it is one dimensional...
Code:
Function combineArray(arr1,arr2)
combineArray = Split(Join(arr1,"%^&") & "%^&" & Join(arr2,"%^&"),"%^&")
End Functionas you had split the string..i am joining back all the array elements as a single string and do a final split to create an array...
But it might not be a good approach...because if the array element itself has the delimiter as content (%^&)..then the result might not be as expected..
so create a function and create an array in it with a size by adding 2 array sizes. then use for loop to iterate thro passed array elements and to store it in the new array.