Small trick in excel

Originally Posted by tim201110

=CONCATENATE(TRANSPOSE(A2:A6&" ")) as arrayformula, select a formula and press F9
in a cell:
={"One, ";"Two, ";"Three, ";"Four, ";"Five "}

Remember: "without use of formula or VBA"