Concatenate array string

[tushar.tarafdar]

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

[Admin]

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/flexible-concatenation-function-313/

[Admin]

Hi

Since your original question has been answered, I moved your new query to a new thread. http://www.excelfox.com/forum/f2/extract-numbers-alphanumeric-values-566/