E
ExcelMonkey
I know I can use the split function on a string to return an array.
Array = Split(var2)
I have 8 string variables that I want to apply the split function to and I
then want to send all these elements into 1 Master Array. Do I still have to
create the 8 individual arrays as a middle step or can bypass this using some
sort of aggregation in brackets like:
MasterArray =
(Split(var1),Split(var2),Split(var3),Split(var4),Split(var5),Split(var6),Split(var7),Split(var8))
Thanks
EM
Array = Split(var2)
I have 8 string variables that I want to apply the split function to and I
then want to send all these elements into 1 Master Array. Do I still have to
create the 8 individual arrays as a middle step or can bypass this using some
sort of aggregation in brackets like:
MasterArray =
(Split(var1),Split(var2),Split(var3),Split(var4),Split(var5),Split(var6),Split(var7),Split(var8))
Thanks
EM