How to concatenate a range of cells into a single cell

Transpose function can be used to create a list of values from a range of cells.  Transpose and concatenate can be used to combine a range of cells into one cell.

Step1: =concatenate(transpose(A2:A6))

Step2: highlight transpose(A2:A6) and press F9 key

Step3: Transpose formula will transform into a list of values

Step4: =CONCATENATE("11,","12,","13,","14,","15,")
concatenate
[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]