Small trick in excel

Does anybody know how to concatenate text from a column into one cell without using formula or VBA with only one click?

Best of luck to all of you

From this

v	A
1
2	One,
3	Two,
4	Three,
5	Four,
6	Five

to this

v	A
1
2	One, Two, Three, Four, Five

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"