The easiest way will be to install the MOREFUNC add-in.
http://www.download.com/Morefunc/300...-10423159.html
Then you may try [among other helpful functions]:
=MCONCAT(D1:D64,"")
Micky
"Joe User" wrote:
What is the most succinct formula to concatenate D1:D64, which contain one
character each?
I thought the following array formula would do the trick:
=concatenate(index(D1:D64,row(1:64)))
It didn't work. Well, I guess I understand why. CONCATENATE({"a","b"})
doesn't work either.
I finally resorted to a macro. But I'm still interested in an Excel
formula.
(Excel 2003 SP3.)
.