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
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/
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
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/
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Bookmarks