Is it possible to concatenate the the output of an array by excel formula?
e.g., my array output is {"0";"f";"e";"w";"3";"2";"1";"m";"a";"k";"e";"8";" 7";"6";"m";"a";"n";"y"}
i want the output as 0few321make876many
Printable View
Is it possible to concatenate the the output of an array by excel formula?
e.g., my array output is {"0";"f";"e";"w";"3";"2";"1";"m";"a";"k";"e";"8";" 7";"6";"m";"a";"n";"y"}
i want the output as 0few321make876many
Hi Tushar,
Welcome to ExcelFox !!!
AFIK, it's not possible. I could be wrong.
BTW, you can try Rick's UDF.
http://www.excelfox.com/forum/f22/fl...-function-313/
Hi
Since your original question has been answered, I moved your new query to a new thread. http://www.excelfox.com/forum/f2/ext...ic-values-566/